- 建立表空间
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;