Connected to: Oracle Database 11g Enterprise Edition
Release 11.1.0.6.0 ??“ Production
With the Partitioning, OLAP, Data Mining
and Real Application Testing options
Starting "RJB"."SYS_EXPORT_TRANSPORTABLE_01": rjb/********
dumpfile=expdat.dmp directory=src_dpump_dir transport_tablespaces=xport_dw
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "RJB"."SYS_EXPORT_TRANSPORTABLE_01" successfully
loaded/unloaded
********************************************************************
Dump file set for RJB.SYS_EXPORT_TRANSPORTABLE_01 is:
/Temp/expdat.dmp
********************************************************************
Datafiles required for transportable tablespace XPORT_DW:
/u02/oradata/xport_dw.dbf
Job "RJB"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 12:00:51
[oracle@dw ~]$ ls -l /Temp/exp*
-rwxrwxrwx 1 root root 86016 Sep 16 12:00 /Temp/expdat.dmp
-rwxrwxrwx 1 root root 1089 Sep 16 12:00 /Temp/export.log
[oracle@dw ~]$
Use DBMS_FILE_TRANSFER to Copy Files
In this step, you will copy the tablespace??™s datafile to the remote database using DBMS_FILE_
TRANSFER, as follows (although you could use the /Temp directory for this step as well):
SQL> execute dbms_file_transfer.put_file(
2 'src_dbf_dir', 'xport_dw.dbf',
3 'dest_dbf_dir', 'xport_dw.dbf', 'rac1');
PL/SQL procedure successfully completed.
Pages:
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878