Import XML
OraDevDec 4 2007 — edited Dec 7 2007hi 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.