Re: One query Two Databases

From: Trevor Bourget <tbourget-REMOVE-_at_racltd.com>
Date: Wed, 25 Sep 2002 14:00:08 -0600
Message-ID: <up45k8o53hjnb5@corp.supernews.com>

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
>
>
Received on Wed Sep 25 2002 - 15:00:08 CDT