drop user aaaa cascade

create user taaaaidentified by "222222";

grant connect,dba to aaa;

alter user aaadefault tablespace ticket temporary tablespace temp;

drop tablespace ticket including contents and datafiles;

create tablespace ticket datafile '/u01/app/oracle/oradata/RACDB/datafile/ticket.dbf' size 100M autoextend on next 10M maxsize 32000M;

create tablespace ticket datafile '/u01/app/oracle/oradata/RACDB/datafile/ticket.dbf' size 50M autoextend on next 10M maxsize unlimited;

本文转自 jxwpx 51CTO博客，原文链接：http://blog.51cto.com/jxwpx/399483，如需转载请自行联系原作者