The DBMS_TTS package checks if the transportable set is self-contained. All violations are inserted into a temporary table that can be selected from the view
This chapter contains the following topics:
189.1 DBMS_TTS Security Model
Only users having the
execute_catalog_role can execute this procedure. This role is initially only assigned to user SYS.
189.2 DBMS_TTS Exceptions
DBMS_TTS package creates exceptions for missing or invalid transportable tablespaces.
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;
189.3 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.
189.4 Summary of DBMS_TTS Subprograms
The two procedures listed in the table are designed to be called by database administrators.
189.4.1 DOWNGRADE Procedure
This procedure downgrades transportable tablespace related data.
189.4.2 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.
DBMS_TTS.TRANSPORT_SET_CHECK ( ts_list IN CLOB, incl_constraints IN BOOLEAN DEFAULT FALSE, full_check IN BOOLEAN DEFAULT FALSE);
Table 189-2 TRANSPORT_SET_CHECK Procedure Parameters
List of one or more tablespaces, separated by comma.
Indicates whether a full or partial dependency check is required. If
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;