Re: Working with 2 schemas

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Mon, 5 Aug 2002 05:37:01 -0500
Message-ID: <ukslafb7vciveb@corp.supernews.com>

If the schema's are in the same instance you can just do a
insert into schema1.tab1
select * from schema2.tab2;

If they are in different instances
you can try to use the SQLPLUS copy command. It does not require a database link.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"SK" <birdieng_at_yahoo.com> wrote in message news:9a5c8521.0208050226.f22c280_at_posting.google.com...
> I need to insert records from one schema to another, but I'm
> restrained from using DB link. Can anyone suggest alternatives?
> Many thanks in advance.
Received on Mon Aug 05 2002 - 05:37:01 CDT