| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Scripts -- Scripts -- Scripts (One more time)
yes, it does :) also functions, tables, views, sequences, etc
>From: "Nancy McCormick" <nmccormick_at_sbti.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Scripts -- Scripts -- Scripts (One more time)
>Date: Fri, 16 Feb 2001 08:31:22 -0800
>
>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)"
><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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Nancy McCormick
> INET: nmccormick_at_sbti.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.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 Feb 16 2001 - 13:45:47 CST
 |
 |