Re: reading oracle dumps

From: Chris Hubble <chubble_at_pcug.org.au>
Date: 1995/05/05
Message-ID: <chubble.4.001C1598_at_pcug.org.au>#1/1


In article <3oa08k$69v_at_news.tuwien.ac.at> mike_at_rainbow.studorg.tuwien.ac.at (Michael Wildpaner) writes:
>From: mike_at_rainbow.studorg.tuwien.ac.at (Michael Wildpaner)
>Subject: reading oracle dumps
>Date: 4 May 1995 07:37:56 GMT
 

>Hello !
 

>To get Oracle-Data into another database (without SQL*net being available on
>the client machine), we're trying to export a database (on a Novell Server)
>into a dump, ftp the dump and update our database.
 

>Is there any description of the Oracle dump format ? As far as we've seen,
>in front of each field there is it's length encoded, but no idea about the
>header.

The ftp of an Oracle export file followed by an import (imp) will do the job.

Don't worry about the format, you don't need it.

>PS: We would also appreciate any pointers to a more elegant method to query
> a novell-oracle database via tcpip. The clients will be linux machines.

The most elegant way is to use SQL*Net. Check the manuals.


Chris Hubble                   chubble_at_pcug.org.au                   06 249 8492 (H)                   
Received on Fri May 05 1995 - 00:00:00 CEST

Original text of this message