Re: Working with 2 schemas

From: Andy <andy.spaven_at_eps-hq.co.uk>
Date: Mon, 5 Aug 2002 11:42:27 +0100
Message-ID: <Xzs39.343$9R.1670212@newsr2.u-net.net>

If the schemas are in the same database instance you don't need a DB Link.

insert into <schema1>.<tablename> select .... from <schema2>.<tablename>

If you are looking at two different databases then try export and import as a quick/well documented route (see the Oracle Utilities manual).

Andy

"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:42:27 CDT