数据库的导入和导出

 exp system/manager@TEST file=d:\daochu.dmp full=y   导出


 imp system/manager@TEST  file=d:\daochu.dmp  导入

 imp system/manager@TEST  file=d:\daochu.dmp  tables=(table1)  导入一个表

comment on column CUSTOMER.last_succ_review_time
  is '最后回访时间';
//备注的插入方法。


 
1. exp zx_xmcc/0592call@192.168.99.251/ORCL file=D:\daochu.dmp  full=y

2. 创建表空间 data indx 
create tablespace data
datafile   'D:\app\clh\oradata\orcl\data.dbf'
SIZE 50M autoextend on next 10M maxsize unlimited extent management local ;

create tablespace indx
datafile   'D:\app\clh\oradata\orcl\indx.dbf'
SIZE 50M autoextend on next 10M maxsize unlimited extent management local ;

 创建用户 
create user xmcc identified by xmcc 
grant resource, connect, dba to xmcc

alter user xmcc quota unlimited on data
alter user xmcc quota unlimited on indx