Oracle DBMS_PLUGTSP
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Internal package supporting transportable tablespace functionality
AUTHID DEFINER
Dependencies
DBMS_PLUGTS DBMS_PLUGTS_LIB DBMS_SYS_ERROR
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 the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsplts.sql
Subprograms
KCP_PD PATCHDICTIONARY PATCHTABLEMETADATA
KCP_PTMD PATCHLOBPROP  
 
KCP_PD
C callout for patch dictionary dbms_plugtsp.kcp_pd(
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
 
KCP_PTMD
C callout for patch table metadata dbms_plugtsp.kcp_ptmd(
schemaName    IN VARCHAR2,        -- schema name
tableName     IN VARCHAR2,        -- table name
mdClob        IN CLOB,            -- data pump's metadata
expSrvrEndian IN BINARY_INTEGER,  -- export server endian
impSrvrEndian IN BINARY_INTEGER); -- import server endian
TBD
 
PATCHDICTIONARY
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

Related Topics
DataPump Executable
DBMS_DATAPUMP
DBMS_EXTENDED_TTS_CHECKS
DBMS_PLUGTS
DBMS_TDB
DBMS_TTS
Export
Import
Packages
Tablespaces
Transportable Tablespaces

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved