We have tables with primary keys, which result in indexes being created. We
do not explicitly create indexes.
How can I ensure that indexes are created in a seperate tablespace from the
tables?
Can I specify this in the create table statement?
Oracle version is 8.1.6
John
--
Please see the
Hi John,
Here is the answer:
CREATE TABLE salgrade
( grade NUMBER CONSTRAINT pk_salgrade
PRIMARY KEY
USING INDEX TABLESPACE users_a,
losal NUMBER,
hisal NUMBER )
TABLESPACE human_resource
STORAGE (INITIAL 6144
NEXT
Yes,
when you specify the primary key in the create table statement also mention
USING INDEX TABLESPACE, this way you can ensure that the index is created in
separate tablespace
Regards
Arun Aggarwal
Aithent Technologies (P) Ltd.
[EMAIL PROTECTED]
+91-11-6920905 (35)
"If I knew what I was so an
as.co.uk>cc:
Sent by: Subject: Creating indexes in seperate
tablesp
John Dunn£¬ÄúºÃ£¡
u can use a clause in the create table command to specify the details of the
primary key,or alter table to add constraint ,using index clause to specify the detail
about the index.
for example:
sql>create table pk
(name char(8),
age number);
sql> alter t