Results for DBMS_TTS


1 to 18 of 18 results.


Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

Using DBMS_TTSSecurity Model Exceptions Operational Notes

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

110 DBMS_TTSThe DBMS_TTS package checks if the transportable set is self-contained. All violations are inserted … topics: Using DBMS_TTS Security Model Exceptions Operational Notes Summary of DBMS_TTS Subprograms

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

Summary of DBMS_TTS SubprogramsThese two procedures are designed to be called by database administrators. Table 110-1  DBMS_TTS

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

Operational NotesWith respect to transportable tablespaces, disabled and enabled referential integrity constraints are handled differently: A disabled referential integrity constraint does not violate the transportability rules and is dropped during the import phase. An enabled referential integrity constraint violates the transportability rules if it references a table in a tablespace outside the transportable set.

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

DOWNGRADE ProcedureThis procedure downgrades transportable tablespace related data.

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

ParametersTable 110-2 TRANSPORT_SET_CHECK Procedure Parameters Parameter Description ts_list List of tablespace, separated by comma. incl_constraints TRUE if you want to count in referential integrity constraints when examining if the set of tablespaces is self-contained. (The incl_constraints parameter is a default so that TRANSPORT_SET_CHECK will work if it is called with only the ts_list argument.) full_check

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

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

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

Exceptionsts_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;

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

ExamplesIf the view does not return any rows, then the set of tablespaces is self-contained. For example, SQLPLUS> EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('foo,bar', TRUE); SQLPLUS> SELECT * FROM TRANSPORT_SET_VIOLATIONS;

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

SyntaxDBMS_TTS.TRANSPORT_SET_CHECK ( ts_list IN VARCHAR2, incl_constraints IN BOOLEAN DEFAULT FALSE, full_check IN BOOLEAN DEFAULT FALSE);

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

SyntaxDBMS_TTS.DOWNGRADE;

Packages and Types Reference, 10g Release 1 (10.1)

110 DBMS_TTS

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

Packages and Types Reference, 10g Release 1 (10.1)

99 DBMS_STREAMS_TABLESPACE_ADM

Overview-contained, use the TRANSPORT_SET_CHECK procedure in the Oracle supplied package DBMS_TTS. See Also

Packages and Types Reference, 10g Release 1 (10.1)

Contents

Contentsof DBMS_XDB_VERSION Subprograms 110 DBMS_TTS Using DBMS_TTS Summary of DBMS_TTS Subprograms 111

Administrator's Guide, 10g Release 1 (10.1)

8 Managing Tablespaces

Transporting Tablespaces Between Databases: A Procedure and Examplethe TRANSPORT_SET_CHECK procedure in the Oracle supplied package DBMS_TTS. You must have been granted … the DBMS_TTS package, you specify the list of tablespaces in the transportable set to be checked for … and Types Reference for more information about the DBMS_TTS package Oracle Database Backup and … Recovery Advanced User's

Guide, 10g Release 1 (10.1)

13 Transportation in Data Warehouses

Transportation Using Transportable Tablespaceswithout the rest of the table. You can use the DBMS_TTS package to check that a tablespace is … transportable. See Also: PL/SQL Packages and Types Reference for detailed information about the DBMS_TTS

Packages and Types Reference, 10g Release 1 (10.1)

1 Introduction

Summary of Oracle Supplied PL/SQL Packagesan interface to the message format transformation features of Oracle Advanced Queuing. DBMS_TTS

Packages and Types Reference, 10g Release 1 (10.1)

What's New in PL/SQL Packages and Types Reference?

Oracle Database 10 g Release 1 (10.1) New FeaturesDBMS_STREAMS DBMS_STREAMS_ADM DBMS_TTS DBMS_TYPES DBMS_UTILITY DBMS_WM DBMS_XDB DBMS_XDB_VERSION DBMS_XMLGEN


Was this page helpful?