NC初始化脚本

---执行过以下脚本
-- 1、建表空间 
CREATE TABLESPACE NNC_DATA01 DATAFILE 'C:\Data\nnc_data01.dbf' SIZE 3G AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
 
CREATE TABLESPACE NNC_INDEX01 DATAFILE 'C:\Data\nnc_index01.dbf' SIZE 3G AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;
 
-- 2、建立用户 
CREATE USER Chen IDENTIFIED BY Chen123456 DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp; 

-- 3、为新建的用户授权 
GRANT connect,dba to Chen with admin option ; 

-- 4、建立数据泵对应目录 
CREATE DIRECTORY my_dir AS 'c:\backup';

-- 5、为所建用户赋予虚拟目录的读写权限 
grant read,write on directory my_dir to Chen; 

-- 6、备份，恢复
expdp kljt/Ys123456@orcl schemas=kljt dumpfile=kljt.dmp logfile=kljt.log directory=my_dir  
impdp Chen/Chen123456  dumpfile=nc57.dmp directory=my_dir remap_tablespace=nc57:Chen remap_schema=nc57:Chen logfile=nc57.log TRANSFORM=segment_attributes:n'