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 -> Re: database links to move data between servers

Re: database links to move data between servers

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Sat, 15 Feb 2003 06:00:17 -0600
Message-ID: <v4sauhd9nk1acc@corp.supernews.com>


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

Original text of this message

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