RE: Index File Name

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:wisernet100_at_yahoo.com]
> 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 <ken.janusz_at_sufsys.com> 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" <ORACLE-L_at_fatcity.com>
> > 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: ken.janusz_at_sufsys.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: Alistair Orchard
> > INET: alistair.b.orchard_at_btinternet.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: Ken Janusz
> > INET: ken.janusz_at_sufsys.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!?
> 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: wisernet100_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: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).