hi

build a query using dba_objects that gives a list of create statments for
all objects you want.

ex. select "create table " , ojbect_name from dba_objects where ...

regards,
Montu


>From: "Amol, Joshi (CAP, GCF, TCS, CONSULTANT)" <Joshi.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] RE: DDL script/Tool
>Date: Thu, 28 Mar 2002 17:51:46 +0100
>
>check out Note:90449.1
>
>-----Original Message-----
>From: Ashish Saxena
>Sent: Thursday, March 28, 2002 5:39 PM
>To: LazyDBA.com Discussion
>Subject: DDL script/Tool
>
>
>Hey Folks,
>
>Good Morning. Is there any script or tool that can
>give me the create script(DDL script) of users,
>tablespaces and their underlying objects? I'm
>preparing an extra bakcup plan for critical customers
>where in I'm exporting their data & also wanting to
>create DDLs(create scripts of all tablespaces, users &
>other objects) of their databases once a day. I know I
>can achive this by EXPORT utility but if there's an
>urgent user(or any object for that matter) creation
>request, I can then just run a script & get the create
>script/DDL of a similar user/object & run it!!! This
>could save a lot of time.
>
>Thanks a lot!
>Ashish
>
>=====
>Ashish Saxena
>Oracle DBA
>Sprint E|Solutions
>Kansas City MO
>eMail: [Email Address Removed] You Yahoo!?
>Yahoo! Movies - coverage of the 74th Academy Awards®
>http://movies.yahoo.com/
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>




_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Oracle LazyDBA home page