Hey John,
Here's my table, index, and PK:
CREATE TABLE MY_TABLE
(
MY_COL NUMBER,
MY_DATA NCHAR(2)
)
TABLESPACE USERS;
CREATE UNIQUE INDEX MY_INDEX ON MY_TABLE
(MY_COL)
TABLESPACE USERS;
ALTER TABLE MY_TABLE ADD (
CONSTRAINT MY_PK
PRIMARY KEY
(MY_COL)
USING INDEX MY_INDEX
ENABLE VALIDATE);
And here's the result I get from the RHS script tab in the SB:
CREATE TABLE MY_TABLE
(
MY_COL NUMBER,
MY_DATA NCHAR(2)
)
TABLESPACE USERS
NOCACHE
RESULT_CACHE (MODE DEFAULT)
/
-- There is no statement for index MY_INDEX.
-- The object is created when the parent object is created.
ALTER TABLE MY_TABLE ADD (
CONSTRAINT MY_PK
PRIMARY KEY
(MY_COL)
USING INDEX
TABLESPACE USERS
ENABLE VALIDATE)
/
-- There is no statement for index MY_INDEX.
-- The object is created when the parent object is created.
In this case, the index needs to be named "MY_INDEX", but the script will create one called "MY_PK" instead.
Thanks!
Rich