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