toad does something similar and then you can always use imp show=y
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"AF" <af_at_nospaming.com> wrote in message
news:a27jha$ou7$1_at_pith.uoregon.edu...
> I was using that othe Product (MSSQL) and the Enterprise manager had a
cool
> feature called "Script All Objects" (I think).
>
> Is there any function in oracle that will do this? In MSSQL you select a
DB
> instance and select which objects: Tables, Indexes, Users, roles... And
it
> will generate a single SQL script that you can run to recreate all objects
> or just a subset (your choice, without data). I want to use this on my
> indexes and users. That way I could export just my data (which is very
> static) for backup.
>
> Thanks in Advance for any help.
> A
>
>
Received on Fri Jan 18 2002 - 02:38:48 CST
