I knew I'd forget something :) thanks Kirti!
--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > And while making sure those tablespaces exist, I would also make sure > that > the user running the script has sufficient quota on those > tablespaces. > > - Kirti > > > -----Original Message----- > > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, November 20, 2001 3:16 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Index File Name > > > > yep, absolutely. > > > > so as long as that tablespace has been created, your script will > run > > > > if I were you, I'd do a search in that script file for the word > > TABLESPACE and find every tablespace name that is used and make > sure > > they exist before I ran the script > > > > --- Ken Janusz <[EMAIL PROTECTED]> wrote: > > > Here is a typical piece of code from the DDL SQL script that > creates > > > an > > > index. It appears that the tablespace used for indexes is > > > SOS2_TBLSPC. > > > Correct? > > > > > > Ken > > > > > > > > > CREATE INDEX FK_AR_ACCESSRIGHTID ON > > > ACCESS_RIGHT(ACCESS_RIGHT_ID) > > > TABLESPACE SOS2_TBLSPC PCTFREE 10 STORAGE(INITIAL 122880 NEXT > > > 106496 > > > PCTINCREASE 0 ) > > > > > > > > > -----Original Message----- > > > Sent: Tuesday, November 20, 2001 2:01 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Index File Name > > > > > > If you don't specify an index tablespace the index will occupy > the > > > same > > > tablespace as the Table... > > > It's probably best to have a tablespace for indexes and one for > the > > > tables > > > If you create an index tablespace, a good name might be > > > 'User_Indexes' ? > > > > > > > > > ----- Original Message ----- > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Tuesday, November 20, 2001 7:25 PM > > > > > > > > > I am creating a database from a DDL SQL script. I have created > the > > > primary > > > and temp tablespaces because their names were referenced in the > code. > > > However, there is no name reference anywhere that I can find for > the > > > "index" > > > tablespace. Do I need to create one, or will Oracle take care of > > > that for > > > me? If I have to create on, what name do I give it, or does it > > > matter? > > > > > > Thanks, > > > Ken Janusz, CPIM > > > Database Conversion Lead > > > Sufficient System, Inc. > > > Minneapolis, MN > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Ken Janusz > > > 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: Alistair Orchard > > > 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: Ken Janusz > > > 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!? > > Yahoo! GeoCities - quick and easy web site hosting, just > $8.95/month. > > http://geocities.yahoo.com/ps/info1 > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > 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: Deshpande, Kirti > 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!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
