Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> One query Two Databases

One query Two Databases

From: Trevor Bourget <tbourget-REMOVE-_at_racltd.com>
Date: Wed, 25 Sep 2002 13:56:49 -0600
Message-ID: <up45e2r8n7k16f@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 - 14:56:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US