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: Which method: dblink or import/export?

Re: Which method: dblink or import/export?

From: Wicksey <Wicksey_at_hotmail.com>
Date: Fri, 23 Apr 1999 13:43:52 +0100
Message-ID: <7fppue$n0k@romeo.logica.co.uk>


I went with the second option when I had to do this although I used Data Manager to import the dat files.

Is it only one table that you need to transfer? If so then I would definitely use SQL Loader. However if you want to export an entire user or database, then I would use Import and Export utilities, imp73.exe and exp73.exe respectively. These are good if you're transferring the entire database from remote to local db.

Hope this helps(!)

Wicksey Received on Fri Apr 23 1999 - 07:43:52 CDT

Original text of this message

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