Hi,
I am altering a table to add a primary key with using index option.
for ex: ALTER TABLE <table_name> ADD CONSTRAINT PRIMARY KEY (<column_name>)
USING INDEX <do we need to give table space name here or index_name>;
if index_name then firstly do we need to create a index on the column on which we need to create a primary key
and then give the index name in the
alter table Script.
Please advice.