| General Information |
| Purpose |
Internal package supporting transportable tablespace functionality |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsplts.sql |
| First Available |
7.3.4 |
| Dependencies |
| DBMS_PLUGTS |
DBMS_SYS_ERROR |
DBMS_PLUGTS_LIB |
|
| 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 |
|
| Security Model |
Execute is granted to the EXECUTE_CATALOG_ROLE |
| |
| 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 |
