Oracle | DBMS

Oracle DBMS_PLUGTSP Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Internal package supporting transportable tablespace functionality

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_PLUGTS_LIB	DBMS_SYS_ERROR
DBMS_PLUGTS	DBMS_STANDARD	KUPCC

Documented No

Exceptions

Error Code	Reason
ORA-29304	Tablespace not found
ORA-29335	Tablespace not readonly
ORA-29336	Internal error
ORA-29338	Datafile not ready
ORA-29339	Blocksize mistmatch
ORA-29340	Export file corrupted
ORA-29341	Not self contained
ORA-29342	User not found
ORA-29343	Mapped user not found
ORA-29344	User not in list
ORA-29345	Different character set
ORA-29346	Invalid tablespace list
ORA-29347	Tablespace not in list
ORA-29348	Datafiles missing
ORA-29349	Tablespace name conflict
ORA-29351	System or Temporary tablespace
ORA-29353	Tablespace list overflow
ORA-39185	Tablespace failure list
ORA-39186	Tablespace list empty
ORA-39187	Not self-contained list

First Available 7.3.4

Security Model Owned by SYS with EXECUTE granted to SYSBACKUP and the EXECUTE_CATALOG_ROLE role

Source {ORACLE_HOME}/rdbms/admin/dbmsplts.sql

Subprograms

Repairs various things that get lost across transport due to no relevant syntax (i.e. options/versions based on compatibility rather than explicit syntax). This is called during TTS import.

Otherwise undocumented. dbms_plugtsp.patchDictionary( str1 IN VARCHAR2, -- schema name str2 IN VARCHAR2, str3 IN VARCHAR2, str4 IN VARCHAR2, str5 IN VARCHAR2, str6 IN VARCHAR2, str7 IN VARCHAR2, bin1 IN BINARY_INTEGER); -- bitmap, etc.

TBD

PATCHLOBPROP

Called by import for pre 10i tts dump files dbms_plugtsp.patchLOBProp( schemaName IN VARCHAR2, -- schema name tableName IN VARCHAR2); -- table name pachup lob property after table recreation

TBD

PATCHTABLEMETADATA

This procedure will finish things up after objects have been created. Patchup table metadata after table has been created at the import site. This procedure is called by DataPump Import. dbms_plugtsp.patchTableMetadata( schemaName IN VARCHAR2, -- schema name tableName IN VARCHAR2, -- table name mdClob IN CLOB, -- data pump's metadata expSrvrEndian IN BINARY_INTEGER, -- export endian impSrvrEndian IN BINARY_INTEGER); -- import endian

TBD