数据库见空间表，用户

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;