Re: Moving Data between databases w/o Database Link

Dear Jacen,

You will need to create a 'communication area' between the two instances. I assume they are not part of a parallel database... ;-) You will need a session on the 'sending' instance and one at the 'receiving' instance.
As exp/imp is no option unloading by SQL*Plus and loading with SQL*Loader will not be an option either.
It may be possible, just guessing (although educated) I admit not having tried it, to create a unix node of the type pipe. With the dbms_file_io (? check the package name! a package doing that is available) send it to the unix pipe in a session on the sending database, and read with the same package the pipe on the receiving instance inserting you data as you read the records.
You may on the other hand use a tool like PowerMart by Informatica which is an ETL (Extract Transform Load) which is often found in datawarehousing and datamart environments.

Good luck and kind regards,

H.

"Jcen" <ancient_97_at_yahoo.com> schreef in bericht news:8pk8n9$2m7$1_at_newton.pacific.net.sg...
> Hi.
>
> Would appreciate any information on the following :
>
> I am faced with the constraint of not having a database link
> between 2 databases. I am looking for a way (other than exp/imp) to move
> the data
> between them. I remembered long time ago in a project far away I used
> PowerBuilder
> to pipe the data between the two databases, can any tools other than
> PowerBuilder do that? Can TOAD do that? (TOAD from Quest software)
>
> Thanks for any information.
>
>
> Regards
> Jacen
>
>
>
Received on Tue Sep 12 2000 - 14:53:28 CDT