Summary of DBMS_TTS Subprograms

These two procedures are designed to be called by database administrators.

Table 77-1 DBMS_TTS Subprograms

Subprogram	Description
TRANSPORT_SET_CHECK Procedure	Checks if a set of tablespaces (to be transported) is self-contained.
DOWNGRADE Procedure	Downgrades transportable tablespace related data.

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. If the view does not return any rows, then the set of tablespaces is self-contained. For example,

SQLPLUS> EXECUTE 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,
   full_closure     IN BOOLEAN DEFAULT FALSE);

Parameters

Table 77-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_closure	Indicates whether a full or partial dependency check is required. If TRUE, treats all IN and OUT pointers (dependencies) and captures them as violations if they are not self-contained in the transportable set. The parameter should be set to TRUE for TSPITR or if a strict version of transportable is desired. By default the parameter is set to false. It will only consider OUT pointers as violations.

DOWNGRADE Procedure

This procedure downgrades transportable tablespace related data.

Syntax

DBMS_TTS.DOWNGRADE;