SQL> create directory dest_dbf_dir as '/u05/oradata';
Directory created.
These directory objects are persistent, and you may use these in the future for other Data
Pump or file-transfer operations.
Check for Tablespace Self-Consistency
Before transporting the XPORT_DW tablespace, you should check to make sure that all objects
in the tablespace are self-contained with the procedure DBMS_TTS.TRANSPORT_SET_CHECK,
as follows:
SQL> exec dbms_tts.transport_set_check('xport_dw', TRUE);
PL/SQL procedure successfully completed.
SQL> select * from transport_set_violations;
no rows selected
Not finding any rows in TRANSPORT_SET_VIOLATIONS means that the tablespace has no
external dependent objects or any objects owned by SYS. This view is re-created every time you
run DBMS_TTS.TRANSPORT_SET_CHECK.
Use expdp to Create Metadata
On the ord database, you will execute the expdp command to export the metadata associated
with the XPORT_DW tablespace after making the XPORT_DW tablespace read-only:
Chapter 16: Managing Large Databases 595
SQL> alter tablespace XPORT_DW read only;
Tablespace altered.
To run expdp, you open an operating system command prompt and perform the metadata
export as follows:
[oracle@dw ~]$ expdp rjb/rjb dumpfile=expdat.dmp
directory=src_dpump_dir transport_tablespaces=xport_dw
Export: Release 11.1.0.6.0 ??“
Production on Sunday, 16 September, 2007 11:59:41
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Pages:
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877