Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to copy data across different schema

How to copy data across different schema

From: Max <massimo.solcia_at_txt.it>
Date: Fri, 9 Nov 2001 13:23:13 +0000 (UTC)
Message-ID: <10f670d3a202521a0bd565d3e6b1e1c2.5339@mygate.mailgate.org>


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:

  1. Giving 'select grant' on source schema to destination schema.
  2. Creating a synonym. But how?

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.ORG
Received on Fri Nov 09 2001 - 07:23:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US