December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_TTS.TRANSPORT_SET_CHECK
(ts_list IN VARCHAR2,
incl_constraints IN BOOLEAN DEFAULT
[,full_closure IN BOOLEAN DEFAULT FALSE]#);
Checks a list of comma-separated tablespaces in ts_list. If incl_constraints, includes referential integrity constraints on check of self-containment. If full_closure (new with Oracle9i), considers all IN and OUT pointers (dependencies) and treats them as violations if they are not self-contained.
PROCEDURE DBMS_TTS.DOWNGRADE;
Downgrades transportable tablespace-related data.