From: "Rich Mycroft" Subject: Re: Generating SQL code for schema objects Date: 2000/07/07 Message-ID: <9nj95.6023$%J6.12285@newsfeed.slurp.net>#1/1 References: <8k27u9$k56$1@unbe.sarenet.es> <8k2j0d$s2c$1@garnet.tc.umn.edu> <001760fa.e031dff7@usw-ex0107-055.remarq.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Trace: newsfeed.slurp.net 962970181 209.144.155.147 (Fri, 07 Jul 2000 06:43:01 CDT) X-MSMail-Priority: Normal NNTP-Posting-Date: Fri, 07 Jul 2000 06:43:01 CDT Newsgroups: comp.databases.oracle.server Seems to me the Autl book (Oracle 8i Administration and Management - Wiley ISBN 0-471-35453-8) had some scripts for this kind of thing. It has a CD with the scripts from the book on it. Rich Mycroft "mkb" wrote in message news:001760fa.e031dff7@usw-ex0107-055.remarq.com... > i have a couple stored procs that go grab the tablespace, table > and index ddl and dump out to the utl_file directory. not > perfect, but they give you all the ddl. if anyone wants copies, > email me at mkb125@yahoo.com > > > ----------------------------------------------------------- > > Got questions? Get answers over the phone at Keen.com. > Up to 100 minutes free! > http://www.keen.com >