Re: Import/export

Paul Blair wrote:

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

Errr.. Can't you write some PL/SQL to do you modifications for you ? you could then migrate the old structure to the new structure within the datbase itself. You have to be on 7.1.3 + though.

Alternatively, you can just use good old sqlplus, set head off
spool <filename>
Select * from <tablename>
spool off

And get a flat file of your data. Dont mess with Exp/Imp This is a pain.

Nick. Nick Clark - fj58_at_dial.pipex.com Received on Sat Mar 30 1996 - 00:00:00 CET