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).
