Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import XML

OraDevDec 4 2007 — edited Dec 7 2007
hi all,
I want to migrate from 11g to 10g so I found that the best solution is to get the XML from the 11g and import it to the 10g.

My first question: I know the how to get a table:

SELECT DBMS_METADATA.GET_XML
('TABLE', 'EMPLOYEES', 'HR')
FROM dual;

I want to know how to get the schema including tables, views program units ...


My second question:
After exporting the XML how to import it into another schema

thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2008
Added on Dec 4 2007
12 comments
560 views