Have you seen the book "SQL and PL/SQL Annotated Archives"? I believe this
should have what you are looking for.
Nancy
-----Original Message-----
ksksksk
Sent: Tuesday, February 13, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L
Thanks to all who replied.
Thanks all who answered.
Mary's script has benn very useful.
Unfortunately, this script does not generate the
"procedure", "packages" and "triggers" scripts.
Does someone have some scripts to do so ?
thanks everybody.
--- "Ruiz, Mary A (CAP, CDI)"
<[EMAIL PROTECTED]> escribió: > Pablo:
> Hola ! Here is something that was posted to the
> list that I have found to be extremely useful. This
> uses a .dmp file produced by exp, and generates ddl
> for your database.
> Buena Suerte.
>
> Mary Ruiz / Atlanta GA
>
> -----Original Message-----
> From: Som Priani
> Sent: Thursday, November 02, 2000 8:12 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Life made easier : Scripts to Extract DDL
> from Export DUMP
>
>
> Hi Listers,
>
> Scenario : Build a test/play database from an export
> dump from Production
> (those monstrous sizes) but do not have disk space
> to accomodate all the
> extents...
>
> Rummaging through the dump file and/or precreating
> tablespaces and objects
> and then importing the rest is the solution!! Even
> if all the SQL scripts
> are available - running them in the order of
> dependency will be quite
> tedious and error prone.
>
> I have created Korn shell scripts to extract the DDL
> for objects which need
> disk space in the database and then to reduce them
> by a factor or set them
> to a fixed value. Please find them at
> http://members.tripod.com/Som_Priani
> The strategy
> Create a new database
>
> Extract the SQL scripts from the export dump using
> the utility
> Resize file and extent sizes ( the editing has been
> automated )
>
> CREATE TABLESPACES
> CREATE ROLLBACK SEGMENTS
> CREATE PROFILES
> CREATE USERS
> CREATE ROLES
> GRANT SYSTEM PRIVS to USERS
> REVOKE SYSTEM GRANTS /ALTER users
> CREATE TABLES
> CREATE INDEXES
> Import with IGNORE=Y to get all the constraints,
> stored programs,
> triggers...
>
> Takes a few minutes to run the whole thing - try it
> out...
> Bouquets and Brickbats welcome!! Please use
> backchannel.
>
> HTH
> Som Priani
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Som Priani
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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!?
Envía mensajes instantáneos y recibe alertas de correo con
Yahoo! Messenger - http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nancy McCormick
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
