Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1087947219.15823_at_yasure>...
>
> Following up on Howard's great advice ... I'd suggest in the future
> using the following syntax:
>
> ALTER TABLE mytest
> ADD CONSTRAINT pk_a
> PRIMARY KEY (a)
> USING INDEX
> PCTFREE 0
> TABLESPACE ...;
Daniel, thanks for advice. But I am in a situation not to modify the
code I have for alter table. And the problem I think is this:
the index is created in another tablespace. When drop table, it may
not be able to drop that index in that tablespace. When submit the
statements again, sqlplus sees that index existing and generates
error. I am writing a script, and try to drop that index in that
tablespace while drop the table, this way I guess I won't see error.
But, I don't know how to do this to drop that index in a different
tablespace. Do you have some idea?
Received on Wed Jun 23 2004 - 06:14:10 CDT
