ORACLE数据库导入导出——YCQL

测试机：

global_name:mesorcl

SID:mesorcl

一、创建表空间和数据文件

SQL> create tablespace MESPRD_TBSP logging DATAFILE'/data/u01/app/oracle/oradata/mesorcl/MESPRD_01.dbf' size 10240m autoextend on next 1000m;
SQL> alter tablespace MESPRD_TBSP add DATAFILE'/data/u01/app/oracle/oradata/mesorcl/MESPRD_02.dbf' size 10240m autoextend on next 1000m;
SQL> alter tablespace MESPRD_TBSP add DATAFILE'/data/u01/app/oracle/oradata/mesorcl/MESPRD_03.dbf' size 10240m autoextend on next 1000m;
SQL> alter tablespace MESPRD_TBSP add DATAFILE'/data/u01/app/oracle/oradata/mesorcl/MESPRD_04.dbf' size 10240m autoextend on next 1000m;
SQL> alter tablespace MESPRD_TBSP add DATAFILE'/data/u01/app/oracle/oradata/mesorcl/MESPRD_05.dbf' size 10240m autoextend on next 1000m;
SQL> create user mesprd identified by "Mes1qaz#EDC" default tablespace MESPRD_TBSP temporary tablespace TEMP profile DEFAULT;

二、创建表空间和数据文件

create directory backup_mes as '/data/backup';
GRANT READ,WRITE ON DIRECTORY backup_mes to MESPRD;

grant connect,dba,resource to MESPRD;

GRANT READ,WRITE ON DIRECTORY backup_mes to system;

三、导入，导出命令

impdp system/**** dumpfile=KSSYMESPRD-10.110.48.2_20201103050002_expdp.dmpdp logfile=KSSYMESPRD-10.110.48.2_20201103050002_expdp.dmpdp.log DIRECTORY=backup_mes SCHEMAS=MESPRD
expdp system/**** DIRECTORY=backup_mes DUMPFILE=MESPRD_TBSP_KSSY_20201104.dmpdp logfile=MESPRD_TBSP_20201104.log full=y compression=all

正式机：

global_name:qlorclprd

SID:qlorclprd

一、创建表空间和数据文件

SQL> create tablespace MESPRD_TBSP logging DATAFILE'/data/u01/app/oracle/oradata/qlorclprd/MESPRD_01.dbf' size 10240m autoextend on next 1000m;
SQL> alter tablespace MESPRD_TBSP add DATAFILE'/data/u01/app/oracle/oradata/qlorclprd/MESPRD_02.dbf' size 10240m autoextend on next 1000m;
SQL> alter tablespace MESPRD_TBSP add DATAFILE'/data/u01/app/oracle/oradata/qlorclprd/MESPRD_03.dbf' size 10240m autoextend on next 1000m;
SQL> alter tablespace MESPRD_TBSP add DATAFILE'/data/u01/app/oracle/oradata/qlorclprd/MESPRD_04.dbf' size 10240m autoextend on next 1000m;
SQL> alter tablespace MESPRD_TBSP add DATAFILE'/data/u01/app/oracle/oradata/qlorclprd/MESPRD_05.dbf' size 10240m autoextend on next 1000m;
SQL> create user mesprd identified by "Mes1qaz#EDC" default tablespace MESPRD_TBSP temporary tablespace TEMP profile DEFAULT;

二、创建表空间和数据文件

create directory backup_mes as '/data/backup';
GRANT READ,WRITE ON DIRECTORY backup_mes to MESPRD;
grant connect,dba,resource to MESPRD;
GRANT READ,WRITE ON DIRECTORY backup_mes to system;

三、导入，导出命令

impdp system/**** dumpfile=KSSYMESPRD-10.110.48.2_20201103050002_expdp.dmpdp logfile=KSSYMESPRD-10.110.48.2_20201103050002_expdp.dmpdp.log DIRECTORY=backup_mes SCHEMAS=MESPRD
expdp system/****  DIRECTORY=backup_mes DUMPFILE=MESPRD_TBSP_KSSY_20201104.dmpdp logfile=MESPRD_TBSP_20201104.log full=y compression=all