Re: Exporting Database

If you want to move data between Oracle databases then you can use oracle export utility. This produces a compact ASCII file containing data, index, views, constraints, etc.(based on the options you select) that another oracle database's import utility can read. For more information read "Oracle7 Server Utilities User's Guide's" Export/Import chapters. If you have Oracle Enterprise Manager then you can use its Data Manager GUI interface to do your export/import.

If you want to export data to ASCII file so that you can import it into other programs like Access or Excel, you can write a SQL script in SQL*Plus, format it the way you want e.g., comma delimited, space delimited and send the output to an ASCII file using the SPOOL command. For more information read "SQL*Plus User's Guide and Reference".

Yuji Shimono wrote in message <34E1FB89.EC4C2380_at_foxinternet.net>...
>Is there a utility or software package that will export an Oracle
>database as a text file?
>
Received on Wed Feb 11 1998 - 00:00:00 CET