-
export/import
Is there a way to copy a schema without using import/export/datapump utility.
Like executing a package in the sys schema.
In 10g.
-
No, the only other way would be to dump each table to a text file and re-load with sql loader.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
I suppose that you could write something to extract the DDL for all the schema objects, modify the owner and possibly the tablespace, execute the result, copy the data over etc., but it's be a very complex task
-
You can use third party tools to copy schema/instance by re-engineering. Intelligent Creator, if i remember right can do accros RDBMS.
"What is past is PROLOGUE"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|