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

Home -> Community -> Usenet -> c.d.o.server -> copying tables(s) from on database instance to another

copying tables(s) from on database instance to another

From: Rahul Dhond <rahuld_at_myway.com>
Date: 22 Jun 2004 12:17:34 -0700
Message-ID: <3b946f8a.0406221117.7682c272@posting.google.com>


Hello All,
  I am trying to copy tables from 1 database instance(say DUMY) to another(TRNG). I used the command

copy from <user>/<passwd>@DUMY to <user>/<passwd>@TRNG create <table> using select * from <table>.

It created the table at the other instance(TRNG) but didnt populate it with data. I am not using Client-Server module. It is 1 Oracle server that I connect to and both my above-mentioned database instances reside on the same server.
If anyone can let me know what I need to modify in the above command or can suggest an alternative method(export/import ?), that would be great. I am new to DBA activities hence explanation in layman terms would be appreciated.
Thanks in advance !

Received on Tue Jun 22 2004 - 14:17:34 CDT

Original text of this message

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