Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: One query Two Databases
"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