Re: One query Two Databases

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 25 Sep 2002 20:06:47 GMT
Message-ID: <3D92174A.461EB1CB@exesolutions.com>

Trevor Bourget wrote:

> The testing database is 8i .. forgot the 'i'
>
> Trevor
>
> "Trevor Bourget" <tbourget-REMOVE-_at_racltd.com> wrote in message
> news:up45e2r8n7k16f_at_corp.supernews.com...
> > Is it possible?
> >
> > What I am trying to do is migrate our tables from the old database (Oracle
> > 7) to our testing database (Oracle 8) without doing an Export/Import
> because
> > we have rearranged the tables to be in slightly different tablespaces.
> >
> > What I am hoping is possible is a
> > INSERT INTO Database2.Table
> > SELECT * from Database1.Table
> > or something like that.
> >
> > Thanks in advance,
> >
> > Trevor
> >
> >

You can certainly create a database link between the two databases and do what you suggest.

INSERT INTO newdb_table
SELECT *
FROM olddb_table_at_old_database;

Daniel Morgan Received on Wed Sep 25 2002 - 15:06:47 CDT