Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_TTS , 2 of 3
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;
DBMS_TTS.TRANSPORT_SET_CHECK ( ts_list IN VARCHAR2, incl_constraints IN BOOLEAN DEFAULT, full_closure IN BOOLEAN DEFAULT FALSE);
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|