52
DBMS_TTS

This 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.

Exceptions

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;

Summary of Subprograms

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

Table 52-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,

SVRMGR> EXECUTE TRANSPORT_SET_CHECK('foo,bar', TRUE);
SVRMGR> SELECT * FROM TRANSPORT_SET_VIOLATIONS;

Syntax

DBMS_TTS.TRANSPORT_SET_CHECK (
   ts_list          IN VARCHAR2, 
   incl_constraints IN BOOLEAN);

Parameters

Table 52-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.