Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: database links to move data between servers
For smaller tables the SQLPLUS COPY Command can be used.
It does not require a database link.
However it has some restrictions. So check it out first.
Then of course as Daniel suggests there is exp/imp.
Stephen C. Ashmore
Brainbench MVP for Oracle Administration
http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'
"jim agans" <jwagans_at_yahoo.com> wrote in message
news:82659da6.0302140831.5b421aa7_at_posting.google.com...
> Hello,
>
> I would like to import production data into a test table for testing
> purposes.
> the production data and test database reside on different servers. I
> have heard a db link will get me from one instance to the next...is
> this correst?
> If so, what is the statement syntax.
>
> thanks
> jwa
Received on Sat Feb 15 2003 - 06:00:17 CST
![]() |
![]() |