Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: database links to move data between servers
Steve Ashmore wrote:
> 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
Note ... be aware that the SQL*Plus copy command is listed as being deprecated in Oracle 10i. So this is no time to start using it.
Daniel Morgan Received on Sat Feb 15 2003 - 17:28:05 CST