1、用system用户建立表空间(CBTS)
create tablespace moon datafile 'E:\programe\ora11\product\11.1.0\db_1\oradata\db\moon.dbf' size 100M reuse autoextend on next 5m maxsize unlimited;
2、用system用户建立新用户(CBTS)
create user moon identified by moon default tablespace moon temporary tablespace TEMP;
3、用system用户给新建立的用户(moon)赋权
grant connect to moon;
grant dba to moon;
grant resource to moon;
4、在Windows的命令行中导入数据
#moon/moon@ORCL ORCL是连接符
imp file=E:\download\moon.dmp userid=moon/mon@moon fromuser=moon touser=moon
5、导出数据库
exp moon/moon@moon file=E:\download\moon.dmp owner=moon
###################################
删除表空间:
DROP TABLESPACE moon including contents and datafiles cascade constraint;
DROP TABLESPACE moon including contents and datafiles cascade constraint;