Oracle 11g r2 使用Data dump 从CentOS 迁移到Window 10
1
源系统和目标系统都建立账号 2
create user username identified by password;
grant connect,resoure to username;
赋予expdp和impdp命令权限: 1
grant exp_full_database,imp_full_database to username;
2
SQL> create user migrate identified by migrate;
User created
2
SQL> grant connect,resource,dba to migrate;
Grant succeeded
2 SQL> grant exp_full_database,153)">5 Step 1: 在源系统上创建目录create directory DPDMP as '/oracle/app/admin/orcl/dpdmp/'; --该目录必须是已经存在的目录(该目录应该用oracle用户创建),否则会报错
6 Step 2: 赋予账号对该目录的权限read,write on directory DPDMP to username;
Step 3: 在源系统端expdp(基于某个用户) expdp username/password@orcl directory= DPDMP dumpfile=XX_schema%U.dmp logfile=XX_schema.log schemas=XX_schema Step 4:将源系统的directory/XX_schema%U.dmp文件拷贝到目标系统这步骤省略 Step 5: 在目标系统上创建目录1
create directory DPDMP as 'E:oracleappAdministratoradminorcldpdmp'; --该目录必须是已经存在的目录,否则会报错
Step 6: 赋予权限on directory impdp to username;
Step 7: 在目标系统端impdp7 > 以下为迁移中可能使用到
select ts.tablespace_name,to_char(dbms_metadata.get_DDl('TABLESPACE',ts.tablespace_name))from dba_tablespaces ts;
select username,default_tablespace,temporary_tablespace,profile,dbms_metadata.get_DDl('USER',username) from dba_users where account_status='OPEN' ;
select table_name,count_rows(table_name) nrows from user_tables ;
select * from dba_datapump_jobs;
8
SQL> alter system set db_recovery_file_dest_size=50G scope=spfile(需要重启数据库生效)
SQL> shutdown immediate;
SQL> startup;
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string E:flash_recovery_area
db_recovery_file_dest_size big integer 50G (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |