| General Information |
|
Note: This 10.2 package has been dropped from 11.1.0.6 onward. In 11gR2 the script {ORACLE_HOME}/rdbms/admin/c1002000.sql drops this package if it exists. |
| Note: RAC's service-based operations use DBMS_SCHEMA_COPY for schema pre-compilation on a service basis |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtupg.plb |
| First Available |
10.1 |
| Dependencies |
| CDEF$ |
DBMS_UPG_DEBUG |
DBMS_UPG_SYSAUTH_CT$ |
| CON$ |
DBMS_UPG_INVALIDATE |
DEPENDENCY$ |
| DBMS_APPS_UPG_WORKING |
DBMS_UPG_OBJAUTH_C0$ |
DUAL |
| DBMS_LOB |
DBMS_UPG_OBJAUTH_CS$ |
LINK$ |
| DBMS_METADATA |
DBMS_UPG_OBJAUTH_CT$ |
OBJ$ |
| DBMS_SCHEMA_COPY |
DBMS_UPG_OBJECT$ |
OBJAUTH$ |
| DBMS_STATS |
DBMS_UPG_RLS_C0$ |
PROCEDUREJAVA$ |
| DBMS_SYS_ERROR |
DBMS_UPG_RLS_CS$ |
RLS$ |
| DBMS_UPGRADE_INTERNAL |
DBMS_UPG_RLS_CT$ |
SYN$ |
| DBMS_UPG_CAT_C0$ |
DBMS_UPG_STATUS$ |
SYSAUTH$ |
| DBMS_UPG_CAT_CS$ |
DBMS_UPG_SYSAUTH_C0$ |
TRIGGER$ |
| DBMS_UPG_CAT_CT$ |
DBMS_UPG_SYSAUTH_CS$ |
USER$ |
| DBMS_UPG_CHANGE$ |
|
|
|
| Exceptions |
| Number |
Description |
| ORA-39310 |
CLEAN_FAILED_CLONE was called out of sequence.
The prior operation was not a schema clone operation or the prior schema clone operation was successful |
| ORA-39311 |
CLONE_RECOVERY was called out of sequence.
The prior operation was not a schema clone operation or the prior schema clone operation was successful |
| ORA-39312 |
The routine DBMS_SCHEMA_COPY.CLEAN_TARGET was called out of sequence. The prior clone operation failed |
| ORA-39313 |
The routine DBMS_SCHEMA_COPY.CLONE was called out of sequence. This error occurred because clone operation was done before |
| ORA-39314 |
SYNC_CODE was called out of sequence. The prior operation was not a schema clone or sync. |
| ORA-39315 |
The routine DBMS_SCHEMA_COPY.SWAP was called out of sequence.
The error occurred because the prior operation was not a schema clone or sync operation |
| ORA-39316 |
CLEAN_UP was called out of sequence. The prior schema clone operation failed.
Call the CLEAN_FAILED_CLONE or CLONE_RECOVERY to clean up or recover from the failed clone operation |
| ORA-39317 |
The routine DBMS_SCHEMA_COPY.VALIDATION_CHECK was called out of sequence.
The error occurred because the prior operation was not one of schema clone, sync, or valdation_check |
|
| Security Model |
Must be run using a privileged account such as SYS |
| Subprograms |
|
| |
| CLEAN_FAILED_CLONE |
| Undocumented |
dbms_schema_copy.clean_failed_clone(
src_sch IN VARCHAR2,
dst_sch IN VARCHAR2,
threads IN NUMBER); |
| exec dbms_schema_copy.clean_failed_clone('UWCLASS', 'ABC', 2); |
| |
| CLEAN_TARGET |
| Removes objects owned by the destination schema if a clone fails |
dbms_schema_copy.clean_target(
dst_sch IN VARCHAR2,
force IN BOOLEAN,
threads IN NUMBER); |
| exec dbms_schema_copy.clean_target('ABC', FALSE, 2); |
| |
| CLEAN_UP |
| Completes the Clone process. Only valid following a cloning. |
dbms_schema_copy.
src_sch IN VARCHAR2,
dst_sch IN VARCHAR2); |
| exec dbms_schema_copy.clean_up('UWCLASS', 'ABC'); |
| |
| CLONE |
| Clones functions, packages, procedures, synonyms, types, and views |
dbms_schema_copy.clone(
src_sch IN VARCHAR2,
dst_sch IN VARCHAR2,
threads IN BINARY_INTEGER,
debug IN BOOLEAN); |
conn / as sysdba
BEGIN
dbms_schema_copy.clone('UWCLASS', 'ABC', 2, FALSE);
dbms_schema_copy.clean_up('UWCLASS', 'ABC');
END;
/ |
| |
| CLONE_RECOVERY |
| Undocumented |
dbms_schema_copy.clone_recovery(
src_sch IN VARCHAR2,
dst_sch IN VARCHAR2,
threads IN NUMBER); |
| exec dbms_schema_copy.clone_recovery('UWCLASS', 'ABC', 2); |
| |
| SWAP |
| Undocumented |
dbms_schema_copy.swap(
src_sch IN VARCHAR2,
dst_sch IN VARCHAR2,
ignore_conflict IN BOOLEAN,
force_swap IN BOOLEAN); |
conn / as sysdba
BEGIN
dbms_schema_copy.clone('ABC', 'DEF', 2, FALSE);
dbms_schema_copy.clean_up('ABC', 'DEF');
END;
/
conn abc/abc
CREATE VIEW abc_view AS
SELECT table_name, tablespace_name
FROM all_tables;
conn def/def
CREATE VIEW def_view AS
SELECT constraint_name, constraint_type
FROM all_constraints;
conn / as sysdba
exec dbms_schema_copy.swap('ABC', 'DEF', TRUE, TRUE);
conn abc/abc
SELECT view_name FROM user_views;
conn def/def
SELECT view_name FROM user_views; |
| |
| SYNC_CODE |
| Undocumented |
dbms_schema_copy.sync_code(
src_sch IN VARCHAR2,
dst_sch IN VARCHAR2,
ignore_conflict IN BOOLEAN,
force_sync IN BOOLEAN) |
| exec dbms_schema_copy.clean_up('UWCLASS', 'ABC', FALSE, TRUE); |
| |
| VALIDATION_CHECK |
| Undocumented |
dbms_schema_copy.validation_check(
src_sch IN VARCHAR2,
dst_sch IN VARCHAR2); |
| exec dbms_schema_copy.clean_up('ABC', 'DEF'); |
