Oracle 11g remote export database

Oracle 11g remote export database 1. Create a TNS string:

zqxt =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 132.97.172.186)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = ora11g)    ))

 

2. query the tablespace SQL of remote data: 1 ),

select distinct 'select dbms_metadata.get_ddl(''TABLESPACE'','''||tablespace_name||''') from dual;' from dba_tables;

Obtain the query SQL for each tablespace. 2) run the SQL statement to find the tablespace. 3. Create a tablespace based on the result of step 1. 4. query the role permissions and tablespace of a remote user:

select * from user_role_privs;     select username,default_tablespace from user_users;

5. Create a user based on the 4th results and grant permissions, roles, and tablespaces to the user.

[sql] CREATE USER ityy_zqfw    IDENTIFIED BY zqfw123  DEFAULT TABLESPACE TBS_ITYY    TEMPORARY TABLESPACE TEMP    PROFILE DEFAULT    ACCOUNT UNLOCK;

[SQL] grant connect, CTXAPP, DBA, resource to ityy_z1_w; [SQL] grant read, write on directory DATA_PUMP_DIR to ityy_z1_w; 6. Create DB_LINKcreate public database link zqxt connect to ityy_z1_w identified by z1_w123 using 'zqxt ';

7. Use the NETWORK_LINK of IMPDP for Migration. impdp ityy_z1_w/z1_w123 directory = DATA_PUMP_DIR network_link = zqxt logfile = ityy. the log execution result is as follows: Import: Release 11.2.0.1.0-Production on Friday June 28 16:52:03 2013 Copyright (c) 1982,200 9, Oracle and/or its affiliates. all rights reserved. connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options to start "ityy_zw.w ". "SYS_IMPORT_SCHEMA_01": ityy_zw.w/********* directory = DATA_PUMP_DIR network_link = zqxt logfile = ityy. log is using the BLOCKS Method for estimation... total estimation of processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA using the BLOCKS method: 24.50 GB processing object type SCHEMA_EXPORT/USERORA-31684: Object Type USER: "handler" processing object type SCHEMA_EXPORT/SYSTEM_GRANT processing object type SCHEMA_EXPORT/ROLE_GRANT processing object type handler/DEFAULT_ROLE processing object type handler/PRE_SCHEMA/PROCACT_SCHEMA processing object type handler/SYNONYM Processing object TYPE SCHEMA_EXPORT/TYPE/TYPE_SPEC processing object TYPE SCHEMA_EXPORT/DB_LINK processing object TYPE SCHEMA_EXPORT/SEQUENCE processing object TYPE SCHEMA_EXPORT/TABLE .. imported "ityy_z1_w ". "X_CUSTOMER" 12878088 rows