Re: Create index automatically....

From: Cong TANG <lai-tang_at_mycity.at>
Date: Wed, 01 Dec 1999 21:41:41 +0100
Message-ID: <38458805.9A32559B@mycity.at>

Please try one of the following

1) Using the "USING INDEX" clause

ALTER TABLE  table_name
ADD CONSTRAINT your_primary_key  PRIMARY KEY (primary_key_column)
USING INDEX
TABLESPACE  your_tablespace;

2) Rebuilding indexes

ALTER INDEX index_name REBUILD
TABLESPACE your_tablespace;
 

NJN wrote:

Oracle 8i for Solaris.

Try to create a table(in tablespace A) with defining one column as PK,
but I want the PK index be created inside the tablespace which is
different from the tablespace A.

In Oracle 8, is it possible that do this using 'Create table....'
command?

Thanks a lot! pls also email me.

Received on Wed Dec 01 1999 - 14:41:41 CST