没有合适的资源?快使用搜索试试~ 我知道了~
数据库导入导出,数据泵方法,导入数据库报错数据库导入导出方法,
资源推荐
资源详情
资源评论
导出数据库:
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_server\oradb\ecpmorcl\oradata\ECPMBJFS\FMIS9999_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmiscomp_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmisindex_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmislob_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmislarge_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\ODS_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmistmp_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 DBMS_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';
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_server\oradb\ecpmorcl\oradata\ECPMBJFS\FMIS9999_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmiscomp_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmisindex_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmislob_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmislarge_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\ODS_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_server\oradb\ecpmorcl\oradata\ECPMBJFS\fmistmp_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 DBMS_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';
EXECUTE IMMEDIATE 'GRANT SELECT ANY DICTIONARY TO ODS';
EXECUTE IMMEDIATE 'GRANT SELECT ANY SEQUENCE TO ODS';
EXECUTE IMMEDIATE 'GRANT CONNECT TO ODS';
EXECUTE IMMEDIATE 'GRANT EXECUTE ANY PROCEDURE TO ODS';
End;
/
CREATE USER FMISTMP IDENTIFIED BY FMISTMP
DEFAULT TABLESPACE FMISTMP TEMPORARY TABLESPACE "TEMP" PROFILE "DEFAULT"
QUOTA UNLIMITED ON FMISTMP ACCOUNT Unlock;
BEGIN
EXECUTE IMMEDIATE 'GRANT CONNECT TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT SELECT ANY TABLE TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT UNLIMITED TABLESPACE TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT CREATE TABLE TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT CREATE VIEW TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT CREATE PUBLIC SYNONYM TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT DROP PUBLIC SYNONYM TO FMISTMP';
End;
/
CREATE USER FMIS9999 IDENTIFIED BY FMIS9999
DEFAULT TABLESPACE FMIS9999 TEMPORARY TABLESPACE TEMP PROFILE Default;
Begin
EXECUTE IMMEDIATE 'GRANT SELECT ANY DICTIONARY TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT ALTER ANY TABLE TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT ALTER SYSTEM TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT ALTER ANY PROCEDURE TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT CONNECT TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT CREATE ANY PROCEDURE TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT SELECT ANY SEQUENCE TO ODS';
EXECUTE IMMEDIATE 'GRANT CONNECT TO ODS';
EXECUTE IMMEDIATE 'GRANT EXECUTE ANY PROCEDURE TO ODS';
End;
/
CREATE USER FMISTMP IDENTIFIED BY FMISTMP
DEFAULT TABLESPACE FMISTMP TEMPORARY TABLESPACE "TEMP" PROFILE "DEFAULT"
QUOTA UNLIMITED ON FMISTMP ACCOUNT Unlock;
BEGIN
EXECUTE IMMEDIATE 'GRANT CONNECT TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT SELECT ANY TABLE TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT UNLIMITED TABLESPACE TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT CREATE TABLE TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT CREATE VIEW TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT CREATE PUBLIC SYNONYM TO FMISTMP';
EXECUTE IMMEDIATE 'GRANT DROP PUBLIC SYNONYM TO FMISTMP';
End;
/
CREATE USER FMIS9999 IDENTIFIED BY FMIS9999
DEFAULT TABLESPACE FMIS9999 TEMPORARY TABLESPACE TEMP PROFILE Default;
Begin
EXECUTE IMMEDIATE 'GRANT SELECT ANY DICTIONARY TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT ALTER ANY TABLE TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT ALTER SYSTEM TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT ALTER ANY PROCEDURE TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT CONNECT TO FMIS9999';
EXECUTE IMMEDIATE 'GRANT CREATE ANY PROCEDURE TO FMIS9999';
剩余7页未读,继续阅读
资源评论
weixin_38806479
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 前端开发-什么是前端开发-关于前端开发的一些相关介绍
- Sora AI-关于文生视频的使用场景说明
- suno AI文生视频的相关教程和介绍使用
- 什么是后端开发-关于后端开发的一些小介绍分享
- Jurassic Pack Vol. II Dinosaurs 侏罗纪包卷恐龙二号Unity游戏模型资源unitypackage
- Jurassic Pack Vol. III Dinosaurs 侏罗纪包卷恐龙三号Unity游戏模型资源unitypackag
- Ultimate Seating Controller 终极座椅控制器Unity游戏开发插件资源unitypackage
- 什么是人工智能-关于人工智能的相关介绍说明
- Figma Converter for Unity适用Unity的Figma转换器Unity游戏开发插件unitypackage
- Creepy Animatronic Anims 令人毛骨悚然的电子动画Unity游戏动画插件资源unitypackage
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功