CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_METADATA_DIFF
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/?
First Available 11.1.0.7

Data Types
CREATE T

Dependencies

DBMS_ASSERT DBMS_METADATA_INT KU$_MULTI_DDLS
DBMS_LOB DBMS_METADATA_UTIL PLITBLM
DBMS_METADATA DBMS_SYS_ERROR XMLTYPE

Exceptions

x

Exception Name Error Code Reason
i 3 I
Security Model ?
 
ADD_DOCUMENT
Undocumented

Overload 1
dbms_metadata_diff.add_document(
handle   IN NUMBER,
document IN xmltype);
TBD
Overload 2 dbms_metadata_diff.add_document(
handle   IN NUMBER,
docuemnt IN CLOB);
TBD
 
CLOSE
Undocumented dbms_metadata_diff.close(handle IN NUMBER);
TBD
 
COMPARE_ALTER

Undocumented
dbms_metadata_diff.compare_alter(
OBJECT_TYPE   IN VARCHAR2,
NAME1         IN VARCHAR2,
NAME2         IN VARCHAR2,
SCHEMA1       IN VARCHAR2,
SCHEMA2       IN VARCHAR2,
NETWORK_LINK1 IN VARCHAR2,
NETWORK_LINK2 IN VARCHAR2)
RETURN CLOB;
TBD
 
COMPARE_ALTER_XML

Undocumented
dbms_metadata_diff.compare_alter_xml(
OBJECT_TYPE   IN VARCHAR2,
NAME1         IN VARCHAR2,
NAME2         IN VARCHAR2,
SCHEMA1       IN VARCHAR2,
SCHEMA2       IN VARCHAR2,
NETWORK_LINK1 IN VARCHAR2,
NETWORK_LINK2 IN VARCHAR2)
RETURN CLOB;
TBD
 
COMPARE_SXML

Undocumented
dbms_metadata_diff.compare_sxml(
OBJECT_TYPE   IN VARCHAR2,
NAME1         IN VARCHAR2,
NAME2         IN VARCHAR2,
SCHEMA1       IN VARCHAR2,
SCHEMA2       IN VARCHAR2,
NETWORK_LINK1 IN VARCHAR2,
NETWORK_LINK2 IN VARCHAR2)
RETURN CLOB;
TBD
 
FETCH_CLOB
Undocumented

Overload 1
dbms_metadata_diff.fetch_clob(handle IN NUMBER) RETURN CLOB;
TBD

Overload 2
dbms_metadata_diff.fetch_clob(
handle IN     NUMBER,
xmldoc IN OUT CLOB)
TBD

Overload 3
dbms_metadata_diff.fetch_clob(
handle IN     NUMBER,
xmldoc IN OUT CLOB,
diffs     OUT BOOLEAN)
TBD
 
OPENC

Undocumented
dbms_metadata_diff.openc(object_type IN VARCHAR2) RETURN NUMBER;
SELECT dbms_metadata_diff.openc('TABLE')
FROM dual;
 
Related Topics
DBMS_METADATA
DBMS_METADATA_UTIL
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [183 users online]    © 2010 psoug.org