Re: Is there an ASCII export tool?

Steve's right, but it has to be SOME script you's have to run in sql*plus to export your ENTIRE database in ASCII.

You'd have to query almost every dictionary table and create scripts using the information from those dictionary tables (like: select 'create table '||table_name||'('||column_name .... from all_tables etc. etc.). Think about constraints, triggers, tablespaces, stored procedures,packages,package_bodies, users, grants etc.etc.

When you're finished with this part, create dump-files using spool in sql-plus, and load them in your new database using sql*load.

This way you will be able to duplicate your entire database via ASCII.

Anyone interested in the scripts (perhaps I'll write them myself)

Stay sharp, Lambert

Steve Corbett <stevec_at_fcs.wa.gov.au> wrote in article <338E2D8B.7B37_at_fcs.wa.gov.au>...
> Keith M Parks wrote:
> >
> > I'd like to be able to export the database in ascii format. I've looked
> > at the documentation and only see import, export, and the loader tool.
> > Import and export only work as binary files and loader only loads. I'd
> > also like to be able to export the results of a query to a ASCII file.
> >
> > Thanks for any info,
> > -KP
>
> use SqlPlus and turn off headings etc and spool to an output file
>
> stevec.
>
Received on Mon Jun 02 1997 - 00:00:00 CEST