Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> copying tables(s) from on database instance to another
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 !