9i allows you to extract XML statements concerning objects, schemas or the
entire database, natively. So I guess your request *is* logical. See
dbms_metadata.get_xml for starters.
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"Feli" <jife_at_ementor.no> wrote in message
news:286d2b8b.0201180805.1556d58b_at_posting.google.com...
> Hello to everybody here,
>
> I would like to do following: We model the DB in PowerDesigner. It is
> possible to save the model where all DB objects are included (TABLES,
> TRIGGERS ...) as XML. I would like to compare an existing ORACLE DB
> (objects belonging to one ORACLE user) with the DB definition
> specified in the XML. I have no practical experience with XML but have
> read a lot about it. So, an idea came to my mind. Is there any set of
> for example ORACLE XML tags (XML format) that could be used by all
> CASE tools producers so that results (models saved as XML for ORACLE
> RDBMS) can be used directly by ORACLE RDBMS? I can imagine then that
> theoreticaly it would be possbile instead of starting SQL script to
> generate the DB to use an ORACLE built-in procedure ??? XML_createDB
> ??? to create the DB from the XML. And at the same way to start
> something called ??? XML_compareDB ??? where the procedure would
> compare the current user objects with those defined in the XML.
>
> Maybe this is too theoretical, maybe not.
>
> Our practical usage would be: After the upgrade of DB is finished (we
> start a set of our SQL alter scripts to upgrade the DB schema) the
> XML_compareDB (with XML of the last DB model) could be started and so
> we could check that the upgraded DB is confidental with the latest
> release.
>
> Doesn't it seem logical?
>
> Thanks for any repsonse concerning this subject. Any link, advice,
> idea is welcome.
>
> Jiri
Received on Fri Jan 18 2002 - 16:27:27 CST
