| 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: Missing DDL?
And then prepare to go bleary eyed reading it :)
while an indexfile produces a runnable sql text, show=y does not.
Lines are wrapped in the middle of words, " appear everywhere.
But it will get you what you want to see
Rachel
>From: "A. Bardeen" <abardeen1_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Missing DDL?
>Date: Wed, 30 May 2001 09:01:19 -0800
>
>Sean,
>
>The indexfile parameter shows only the create table
>statements (REM'd out) and the additional indexes (i.e
>not indexes used to enforce PK constraints).
>
>To see all the DDL, use the SHOW=Y parameter along
>with LOG=<filename>.
>
>HTH,
>
>-- Anita
>
>--- "O'Neill, Sean" <Sean.ONeill_at_organon.ie> wrote:
> > Created a sandbox database using Database
> > Administration utiltity, (8i Rel
> > 3, PE, NT4). I ran full export of a database. I
> > then used the imp utility
> > with indexfile parameter to create the DDL for the
> > database. I expected to
> > be able to find the DDL for the tablespaces TOOLS,
> > USERS and some others but
> > can't. OK, so there are no tables created in them
> > but I'm puzzled now as to
> > how these tablespaces are created during import?.
> > Probably missing
> > something obvious, but anyones sane input would be
> > appreciated!.
> >
> >
> > Sean :)
> >
> > Rookie Data Base Administrator
> > [0%] OCP Oracle8i DBA
> > [0%] OCP Oracle9i DBA
> > -------------------------------- ------------
> > Organon (Ireland) Ltd.
> > E-mail: sean.oneill_at_organon.ie [subscribed: Digest
> > Mode]
> >
> > Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
> >
> > "Nobody loves me but my mother... and she could be
> > jivin' too." - BB King
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: O'Neill, Sean
> > INET: Sean.ONeill_at_organon.ie
> >
> > 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 personalized email addresses from Yahoo! Mail - only $35
>a year! http://personal.mail.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: A. Bardeen
> INET: abardeen1_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).
-- 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 Wed May 30 2001 - 12:58:24 CDT
 |
 |