Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to copy data across different schema
I should copy some data from one schema to another into the same DB (Oracle
8.0.6). There are many identical source schema in the system:
Example:
schema1 -> copy -> schema2
schema3 -> copy -> schema4
schema1 and schema2 have the same objects (tables, indexes, etc) schema3 and schema4 have the same objects (tables, indexes, etc)
I suppose two different ways:
Which are benefits of each way?
Is there another way to do this, isn't there?
Thanks in advance
Max
-- Posted from [62.101.65.6] via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Fri Nov 09 2001 - 07:23:13 CST