In the following scenario, you will use expdp and impdp along with DBMS_FILE_TRANSFER
to copy the XPORT_DW tablespace from the dw database to the rac1 database. Here are the
high-level steps:
1. Set up the directories on the source and target databases for the dump file sets and the
tablespace datafiles (one-time setup).
2. Check for tablespace self-consistency with DBMS_TTS.TRANSPORT_SET_CHECK.
594 Oracle Database 11g DBA Handbook
3. Use expdp to create the metadata for the XPORT_DW tablespace.
4. Use DBMS_FILE_TRANSFER to copy the dump file set(s) and datafile(s) to the target
database.
5. On the target database, use impdp to ???plug in??? the tablespace.
Set Up Directory Objects
On the source database, dw, you need to create the directory objects that will hold the dump file
set as well as a directory object that points to the location where the datafile for the XPORT_DW
tablespace is stored. Here are the SQL commands on the ord database; the file system directory /
Temp is common to all servers:
SQL> create directory src_dpump_dir as '/Temp';
Directory created.
SQL> create directory src_dbf_dir as '/u02/oradata';
Directory created.
TIP
If the source or target tablespace are stored in an ASM disk group,
you must use ftp with the /sys/asm virtual directory in the XML
DB repository, DBMS_FILE_TRANSFER, or the cp command in the
asmcmd utility.
On the destination database, rac1, you will execute similar commands, as you can see here:
SQL> create directory dest_dpump_dir as '/Temp';
Directory created.
Pages:
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876