Import/export

From: Paul Blair <pblair_at_pcug.org.au>
Date: 1996/03/29
Message-ID: <315c6546.1046461_at_newshost.pcug.org.au>#1/1

I'm no expert in ORACLE, but I do need a bit of advice, so here goes.

We have an ORACLE database, with an SQL Windows front end. The database needs major updating, and the SQL-W front end is a dog.

We would like to tip the contents of the tables into something simple to allow fast alterations, then tip that lot back into Oracle.

I see functions like IMP and EXP, but it seems that they produce only an archive, non-readable by other means. So, if we try to edit anything created with EXP, we face IMP problems.

Can anyone suggest that (1) I'm wrong about all this or (2) the situation is as described. If (2), then are there any other methods or utilities that would allow us to do the job?

Appreciate any advice

Paul Blair
Canberra, Australia

---

Paul Blair
pblair_at_pcug.org.au or
pblair_at_email.dot.gov.au Received on Fri Mar 29 1996 - 00:00:00 CET