And just to add to that - make sure that the user has the appropriate
privileges on the system, such as CREATE TABLE / INDEX, or the role RESOURCE
or whatever.. :)
Just to nitpick :)
-----Original Message-----
Carmichael
Sent: 21 November 2001 09:35
To: Multiple recipients of list ORACLE-L
I knew I'd forget something :) thanks Kirti!
- "Deshpande, Kirti" <kirti.deshpande_at_verizon.com> 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: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).
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: Mark Leith
INET: mark_at_cool-tools.co.uk
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 Nov 21 2001 - 05:38:26 CST
