I've got a couple of PL/SQL scripts that grab the
table and index DDL and dump out to a file. They'll
do it for a particular schema. I'm also in middle of
converting them over to perl so I'll send that to you
as well. Let me know if you have questions.
hth
mkb
- Sam Bootsma <SamB_at_cpas.com> wrote:
> Hello,
>
> Can anybody help me with a script or tool that will
> generate SQL to recreate
> all tables and all indexes in a schema? I DO NOT
> want the script to
> generate storage parameters.
>
> If anybody has a script that does this, or can
> suggest a free tool, please
> let me know. I need to recreate all tables and
> indexes for about 20
> schemas. I need the tables and indexes to inherit
> storage parameters from
> the tablespace. My plan is as follows:
> 1) Create dump file of each of the existing schema's
> 2) Run the script to generate SQL to create all
> tables and all indexes in
> the schema
> 3) Drop the original schema using cascade option
> 4) Recreate the schema with appropriate privileges
> (schema will be empty at
> this point with no objects)
> 5) Precreate the tables and indexes (with no storage
> parameters) using the
> script generated in step 2)
> 6) Import (specifying ignore=y) data into the
> pre-created tables using the
> dump file created in step 1)
>
> We are running Oracle 8.1.6 on Windows NT.
>
> Thanks!
>
> Sam Bootsma, OCP
> Technical Support Analyst
> CPAS Systems Inc.
> 416-422-0563 x237
> samb_at_cpas.com
> http://www.cpas.com
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Sam Bootsma
> INET: SamB_at_cpas.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
INET: mkb125_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Sep 07 2001 - 14:02:38 CDT