Oracle 表空间操作

• 建立表空间

       sqlplus system/system@localitdev

 

       select file#,name from v$datafile;

 

       create tablespace lelong datafile 'F:\ORACLE\ORADATA\ITDEV\lelong .dbf' size 100m autoextend on next 20m maxsize unlimited;

 

       create user lelong identified by lelong default tablespace lelong temporary tablespace TEMP;

 

       grant connect,resource,imp_full_database,exp_full_database,create public synonym,drop public synonym to lelong ;

 

• 查看表空间

       SQL> select tablespace_name,file_id,file_name,round(bytes/(1024*1024),0) total_s
pace from dba_data_files order by tablespace_name

 

• 删除表空间

       SQL> drop tablespace lelong including contents and datafiles;

 

• 删除用户

       select * from all_users; select * from user_users

       drop user lelong cascade;