Navicat Premium 11.1.17激活(数据泵导入导出方法)

导出数据库：

Expdp system/SYSTEM@ecpm dumpfile=EXPDP_EPCMDB_2017-03-17_1521.DMP logfile=EXPDP_EPCMDB_2017-03-17_1521.LOG schemas=FMIS9999 comparesion=ALL version=11.1.0

Expdp system/SYSTEM@ecpm dumpfile=FMISTMP.DMP logfile=FIMIS9999.LOG schemas=FMISTMP comparesion=ALL version=11.1.0

Expdp system/SYSTEM@ecpm dumpfile=ODS.DMP logfile=FIMIS9999.LOG schemas=ODS comparesion=ALL version=11.1.0

———————————–若数据库没有执行按照以上步骤执行————————————————

以系统管理员SYS/SYS、SYSTEM/SYSTEM 登录

1、创建表空间，注意创建表空间存储位置(例如北京房山地址：)

CREATE TABLESPACE FMIS9999 DATAFILE ’C:app_serveroradbecpmorcloradataECPMBJFSFMIS9999_1.dbf’ Size 1024M AUTOEXTEND ON NOLOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT Auto;

CREATE TABLESPACE FMISCOMP DATAFILE ’C:app_serveroradbecpmorcloradataECPMBJFSfmiscomp_1.dbf’ Size 200M AUTOEXTEND ON NOLOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT Auto;

CREATE TABLESPACE FMISINDEX DATAFILE ’C:app_serveroradbecpmorcloradataECPMBJFSfmisindex_1.dbf’ Size 200M AUTOEXTEND ON NOLOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT Auto;

CREATE TABLESPACE FMIS_LOB DATAFILE ’C:app_serveroradbecpmorcloradataECPMBJFSfmislob_1.dbf’ Size 200M AUTOEXTEND ON NOLOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT Auto;

CREATE TABLESPACE FMIS_LARGE DATAFILE ’C:app_serveroradbecpmorcloradataECPMBJFSfmislarge_1.dbf’ Size 200M AUTOEXTEND ON NOLOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT Auto;

CREATE TABLESPACE ODS DATAFILE ’C:app_serveroradbecpmorcloradataECPMBJFSODS_1.dbf’ Size 200M AUTOEXTEND ON NOLOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT Auto;

CREATE TABLESPACE FMISTMP DATAFILE ’C:app_serveroradbecpmorcloradataECPMBJFSfmistmp_1.dbf’ Size 200M AUTOEXTEND ON NOLOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT Auto;

2、增加PLUBLIC用户授权

GRANT EXECUTE ON DBMS_RLS TO PUBLIC;

GRANT EXECUTE ON DBNavicat Premium 11.1.17激活MS_SESSION TO PUBLIC;

3、创建3个用户（ODS、FMISTMP、FMIS9999）及授权

CREATE USER ODS IDENTIFIED BY ODS QUOTA UNLIMITED ON ODS;

BEGIN 

EXECUTE IMMEDIATE ’GRANT RESOURCE TO ODS’;

EXECUTE IMMEDIATE ’GRANT SELECT ANY TABLE TO ODS’;

今天的文章
Navicat Premium 11.1.17激活(数据泵导入导出方法)分享到此就结束了，感谢您的阅读。