Sorry for the assumption... :o)
I do find it best to specify the tablespace of the
index to be different than the table, personally I use have a method of
leaving:
DB Object code i.e. packages in the users default
tablespace, Tables in one tablespace (i.e. Users_Tables) and indexes in another
(User_indexes) over several disks to reduce <FONT face=Arial
size=2>disk contention. Schemas will require a Temporary Tablespace and you of
course will need the rollback tablespace as a non system tablespace cannot use
the system rollback... a few public rollback segments, named in the
init(SID).ora so they start up automatically with the instance
etc etc.
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A title=lisa.koivu_at_efairfield.com
href="mailto:lisa.koivu_at_efairfield.com">Koivu, Lisa
To: <A title=ORACLE-L_at_fatcity.com
href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L
Sent: Tuesday, November 20, 2001 8:20
PM
Subject: RE: Index File Name
Alistair,
The index will be created in the
default tablespace of the user, not in the tablespace of the table. Try
it and check the results.
If you create the index in the same sql
statement as the table (like the primary key) then yes it may end up in the
same ts as the table.
Lisa Koivu Oracle Database
Monkey Fairfield Resorts, Inc. <FONT
face=Georgia>954-935-4117
-----Original Message----- <FONT
face=Arial size=1>From: <FONT face=Arial
size=1>Alistair Orchard [SMTP:alistair.b.orchard_at_btinternet.com]
Sent: <FONT face=Arial
size=1>Tuesday, November 20, 2001 3:01 PM <FONT face=Arial
size=1>To: <FONT face=Arial
size=1>Multiple recipients of list ORACLE-L <FONT face=Arial
size=1>Subject: <FONT
face=Arial size=1>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 <FONT face=Arial
size=2>If you create an index tablespace, a good name might be
'User_Indexes' ?
- Original Message ----- <FONT
face=Arial size=2>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 <FONT face=Arial
size=2>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" <FONT face=Arial
size=2>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: <A target=_blank
href="http://www.orafaq.com">http://www.orafaq.com <FONT
face=Arial size=2>-- Author: Ken
Janusz INET:
ken.janusz_at_sufsys.com
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 <FONT face=Arial
size=2>San Diego, California --
Public Internet access / Mailing Lists <FONT face=Arial
size=2>--------------------------------------------------------------------
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 <FONT face=Arial
size=2>also send the HELP command for other information (like
subscribing).
- Please see
the official ORACLE-L FAQ: <A target=_blank
href="http://www.orafaq.com">http://www.orafaq.com <FONT
face=Arial size=2>-- Author: Alistair
Orchard INET:
alistair.b.orchard_at_btinternet.com
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 <FONT face=Arial
size=2>San Diego, California --
Public Internet access / Mailing Lists <FONT face=Arial
size=2>--------------------------------------------------------------------
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 <FONT face=Arial
size=2>also send the HELP command for other information (like
subscribing).
Received on Tue Nov 20 2001 - 15:31:37 CST