Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Script all objects Like MSSQL

Script all objects Like MSSQL

From: AF <af_at_nospaming.com>
Date: Thu, 17 Jan 2002 14:30:25 -0800
Message-ID: <a27jha$ou7$1@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 Thu Jan 17 2002 - 16:30:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US