203 DBMS_TTS
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 TRANSPORT_SET_VIOLATIONS
.
This chapter contains the following topics:
203.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.
203.2 DBMS_TTS Exceptions
The 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;
203.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.
203.4 Summary of DBMS_TTS Subprograms
The two procedures listed in the table are designed to be called by database administrators.
Table 203-1 DBMS_TTS Package Subprograms
Subprogram | Description |
---|---|
Downgrades transportable tablespace-related data |
|
Checks if a set of tablespaces (to be transported) is self-contained |
203.4.1 DOWNGRADE Procedure
This procedure downgrades transportable tablespace related data in releases earlier than Oracle Database 10g.
Syntax
DBMS_TTS.DOWNGRADE;
Note:
This procedure has no effect in Oracle Database 10g and later releases. It is included only for backward compatibility to support references to it in existing scripts.203.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.
Syntax
DBMS_TTS.TRANSPORT_SET_CHECK ( ts_list IN CLOB, incl_constraints IN BOOLEAN DEFAULT FALSE, full_check IN BOOLEAN DEFAULT FALSE);
Parameters
Table 203-2 TRANSPORT_SET_CHECK Procedure Parameters
Parameter | Description |
---|---|
|
List of one or more tablespaces, separated by comma. |
|
|
|
Indicates whether a full or partial dependency check is required. If |
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;