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:
Only users having the
execute_catalog_role can execute this procedure. This role is initially only assigned to user SYS.
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;
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.
The two procedures listed in the table are designed to be called by database administrators.
This procedure downgrades transportable tablespace related data.
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 176-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;