Oracle8i Supplied Packages Reference
Release 8.1.5

A68001-01

Library

Product

Contents

Index

Prev Next

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.

See Also:

Oracle8i Administrator's Guide and Oracle8i Migration  

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

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
Parameter  Description 
ts_list
 

List of tablespace, separated by comma.  

incl_constraints
 

TRUE if you'd like to count in referential integrity constraints when examining if the set of tablespaces is self-contained.  

DOWNGRADE procedure

This procedure downgrades transportable tablespace related data.

Syntax

DBMS_TTS.DOWNGRADE;

Parameters

None.




Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index