Using Oracle
dbms_tts
To verify that
the transported tablespace is self-containing,
execute the Oracle dbms_tts package
dbms_tts.transport_set_check
procedure:
SETEXEC DBMS_TTS.TRANSPORT_SET_CHECK(TS_LIST
=>'ADMIN', INCL_CONSTRAINTS => TRUE);
SQL> SELECT *
FROM TRANSPORT_SET_VIOLATIONS;
DECLARE X BOOLEAN;
BEGIN
More tips about using dbms_tts can be found here:
dbms_tts
Tips
|
|
 |
|
Inside the DBMS Packages
The DBMS packages form the foundation of
Oracle DBA functionality. Now, Paulo Portugal writes a landmark book
Advanced Oracle DBMS Packages: The Definitive Reference.
This is a must-have book complete with a code
depot of working examples for all of the major DBMS packages.
Order directly from Rampant and save 30%.
|
|
|
|
|
