Summary of Subprograms

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

Table 55-1 DBMS_TTS Package Subprograms

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);

Parameters

Table 55-2 TRANSPORT_SET_CHECK Procedure Parameters

ts_list

incl_constraints

DOWNGRADE Procedure

This procedure downgrades transportable tablespace related data.

Syntax

DBMS_TTS.DOWNGRADE;

Parameters

None.