表空间的建立
Create TableSpace User_Data2
DataFile 'g:\User_Data2.dbf' Size 100M
AutoExtend On Next 1M
MaxSize 200M;
表空间的查询
Select * From User_TableSpaces;
Select * From User_Free_Space;
用户的建立
Create User cat Identified By mouse
Default Tablespace User_data2
Temporary Tablespace Temp;
用户授权
Grant Connect To cat ;
Grant Resource To cat;
Grant Dba To cat;