Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Script all objects Like MSSQL
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
![]() |
![]() |