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 LazyDBA home page