Re: Script all objects Like MSSQL

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Thu, 17 Jan 2002 17:51:18 +0000
Message-ID: <3C470F16.73D7002B@exesolutions.com>

You can do this in Oracle with EXP (export). You can also do it with countless third-party products.

Daniel Morgan

AF wrote:

> 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 Thu Jan 17 2002 - 11:51:18 CST