Re: One query Two Databases

From: Kevin Gillins <k.gillins_at_verizon.net>
Date: Thu, 26 Sep 2002 10:40:44 -0400
Message-ID: <amv6hl$c9q$1@nntp-m01.news.aol.com>

"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
>
>

Even with moving tables to different tablespace you can use export/import. All you need to do is pre-create your tables in the tablespaces you desire before import. Then on the import process use ignore=Y. The data should import to the tables you pre-created in the tablespaces you want. Kevin Received on Thu Sep 26 2002 - 09:40:44 CDT