Hello All,
I have a requirement that I need to import data on top of production data in
test environment later the same process is applied in production.
I imported production data in test env and disabled primary key and dropped
Index based on primary keys
ALTER TABLE my_table DISABLE CONSTRAINT MY_TABLE_PK;
DROP INDEX MY_TABLE_PK
I import new data to my_table.
I need to delete records that are created my importing my table on top of
production data. I have the script for this
Now the issue is I need to Enable Primary key and create the Index but I do
see the create index statement in the production create SQL statement.
My question is; if I Enable the Primary Key does it create index or I have
to create the index and if so how?