NCX数据库导入导出

一、创建表空间

CREATE TABLESPACE NNC_DATA01 DATAFILE 'C:\Users\bigst\Desktop\jsce\NNC6_DATA01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;

CREATE TABLESPACE NNC_INDEX01 DATAFILE 'C:\Users\bigst\Desktop\jsce\NNC_INDEX01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

二、创建用户并授权

CREATE USER nc11 IDENTIFIED BY 1 DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;

grant connect,dba to nc11;

三、expdp

3.1 文件准备

select * from dba_directories;

create directory jsce as 'C:\Users\bigst\Desktop\jsce';

grant read,write on directory jsce to nc11;

3.2 导出

expdp NC64/NC64@orcl directory=dir_0227 schemas=NC64 dumpfile=NC64.dmp logfile=NC64.log

语句分解为，导出文件和日志的名字是自己取的