Re: novice

trainim_at_ciip.it (Marco Traini) wrote in message news:<47b5f398.0106140009.4881d0e4_at_posting.google.com>...
> Perhaps it's a silly question, but I'm novice in Oracle.
>
> Looking for a way to produce an ascii file with sql commands inside
> (that I can run with sqlplus) with the schema of all the objects of a
> user (table and indexes, grant, synonyms....).
> Export doesn't work, it's not ascii. I need this file to provide the
> schema to my customers to recreate the whole database in another
> environment (Informix, Sybase...).
> I found the way to have the schema of ONE table with TOAD, but I can't
> use it: I have 400 tables!
>
> Many thaks for you help
>
> Marco Traini
> --------------------------------------------------------------------------
> Consorzio Idrico Intercomunale Piceno
> Servizio Informatico
> trainim_at_ciip.it <mailto:trainim_at_ciip.it>
> -----------------------------------------------------------

Choose (in Toad)
Database
Export
Table scripts...

and you're there.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Jun 14 2001 - 15:02:35 CEST