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)"
<Mary.Ruiz_at_gecapital.com> 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: spriani_at_noida.hcltech.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!?
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: p_rodri99_at_yahoo.es
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 Tue Feb 13 2001 - 13:00:15 CST
