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

Only users having the execute_catalog_role can execute this procedure. This role is initially only assigned to user SYS.

See Also: Oracle9i Database Administrator's Guide and Oracle9i Database Migration

This chapter discusses the following topics:

• Exceptions

• Summary of DBMS_TTS Subprograms

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 DBMS_TTS Subprograms

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

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