From: "Thierry Poels" <Thierry.Poels@nospam>
Newsgroups: comp.databases.oracle.misc
References: <8rthfj$phj$1@nnrp1.deja.com>
Subject: Re: copy data between instances
Lines: 27
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Organization: Ye 'Ol Disorganized NNTPCache groupie
Message-ID: <971162735.121783@zenana.dcz.bekaert.com>
Cache-Post-Path: zenana.dcz.bekaert.com!unknown@dcz01s31.dcz.bekaert.com
X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/)
Date: Tue, 10 Oct 2000 07:25:36 GMT
NNTP-Posting-Host: 193.74.166.99
X-Complaints-To: abuse@Belgium.EU.net
X-Trace: nreader1.kpnqwest.net 971162736 193.74.166.99 (Tue, 10 Oct 2000 09:25:36 MET DST)
NNTP-Posting-Date: Tue, 10 Oct 2000 09:25:36 MET DST


Hi,

how about a simple database link ??
You'll be able to access the tables in the other database (more or less)
like any local table.

regards,
Thierry Poels
HP-UX Sysadmin & Oracle DBA.



bdg@hotmail.com wrote in message <8rthfj$phj$1@nnrp1.deja.com>...
>Do any utilities exist that would provide SQL*Loader performance, but
>use another Oracle database (on same host) as the data source instead of
>a text file?  Essentially I would like the basic export/import
>functionality, without having to create an interim dump file.  Import
>also seems to be lacking parallel and direct path performance features.
>
>Brian Gastineau
>Gulf Coast Regional Blood Center
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.