Using DBMS_TTS → Security Model Exceptions Operational Notes
110 DBMS_TTS → The DBMS_TTS package checks if the transportable set is self-contained. All violations are inserted … topics: Using DBMS_TTS Security Model Exceptions Operational Notes Summary of DBMS_TTS Subprograms
Summary of DBMS_TTS Subprograms → These two procedures are designed to be called by database administrators. Table 110-1 DBMS_TTS
Operational Notes → With respect to transportable tablespaces, disabled and enabled referential integrity constraints are handled differently: A disabled referential integrity constraint does not violate the transportability rules and is dropped during the import phase. An enabled referential integrity constraint violates the transportability rules if it references a table in a tablespace outside the transportable set.
DOWNGRADE Procedure → This procedure downgrades transportable tablespace related data.
Parameters → Table 110-2 TRANSPORT_SET_CHECK Procedure Parameters Parameter Description ts_list List of tablespace, separated by comma. incl_constraints TRUE if you want to count in referential integrity constraints when examining if the set of tablespaces is self-contained. (The incl_constraints parameter is a default so that TRANSPORT_SET_CHECK will work if it is called with only the ts_list argument.) full_check
Security Model → Only users having the execute_catalog_role can execute this procedure. This role is initially only assigned to user SYS.
Exceptions → ts_not_found EXCEPTION; PRAGMA exception_init(ts_not_found, -29304); ts_not_found_num NUMBER:= -29304; invalid_ts_list EXCEPTION; PRAGMA exception_init(invalid_ts_list, -29346); invalid_ts_list_num NUMBER:= -29346; sys_or_tmp_ts EXCEPTION; PRAGMA exception_init(sys_or_tmp_ts, -29351); sys_or_tmp_ts_num NUMBER:= -29351;
Examples → If the view does not return any rows, then the set of tablespaces is self-contained. For example, SQLPLUS> EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('foo,bar', TRUE); SQLPLUS> SELECT * FROM TRANSPORT_SET_VIOLATIONS;
Syntax → DBMS_TTS.TRANSPORT_SET_CHECK ( ts_list IN VARCHAR2, incl_constraints IN BOOLEAN DEFAULT FALSE, full_check IN BOOLEAN DEFAULT FALSE);
TRANSPORT_SET_CHECK Procedure → This procedure checks if a set of tablespaces (to be transported) is self-contained. After calling this procedure, the user may select from a view to see a list of violations, if there are any.
Overview → -contained, use the TRANSPORT_SET_CHECK procedure in the Oracle supplied package DBMS_TTS. See Also
Contents → of DBMS_XDB_VERSION Subprograms 110 DBMS_TTS Using DBMS_TTS Summary of DBMS_TTS Subprograms 111
Transporting Tablespaces Between Databases: A Procedure and Example → the TRANSPORT_SET_CHECK procedure in the Oracle supplied package DBMS_TTS. You must have been granted … the DBMS_TTS package, you specify the list of tablespaces in the transportable set to be checked for … and Types Reference for more information about the DBMS_TTS package Oracle Database Backup and … Recovery Advanced User's
Transportation Using Transportable Tablespaces → without the rest of the table. You can use the DBMS_TTS package to check that a tablespace is … transportable. See Also: PL/SQL Packages and Types Reference for detailed information about the DBMS_TTS
Summary of Oracle Supplied PL/SQL Packages → an interface to the message format transformation features of Oracle Advanced Queuing. DBMS_TTS
Oracle Database 10 g Release 1 (10.1) New Features → DBMS_STREAMS DBMS_STREAMS_ADM DBMS_TTS DBMS_TYPES DBMS_UTILITY DBMS_WM DBMS_XDB DBMS_XDB_VERSION DBMS_XMLGEN