| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index Tablespace
Fahd,
create a special userid that you will use to create indexes and assign
the default tablespace to the tablespace you want to use for the
indexes. OR you could alter the default tablespace for the userid that
you are using to create the indexes.
The simplest and best method is to use the tablespace clause in the
create index script and document it with a script.
Ron
>>> SinardyXing_at_bkgcomsvc.com 05/19/2004 2:26:10 AM >>> no idea about other version but 8i, can't do that
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fahd Mirza
Sent: 19 May 2004 14:24
To: oracle-l_at_freelists.org
Subject: Index Tablespace
Hi listers,
I want to use a default tablespace of all indexes other then INDX
=
tablespace or the default tablespace of user. How can I do that, please
=
help.
thanks,
regards,
Fahd
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |