Maria Miller
Member
I've noticed that when I use Oracle exp/imp to refresh business data in Dev from Prod, some indices that are tied to primary key constraints get created in the 'T' tablespace. I'd like to put these in the proper 'I' tablespace. Because the index is tied to a primary key constraint, I first need to drop the primary key constaint before I can drop and rebuild the index. Then I need to add the primary key constraint.
How are people handling rebuilding indices that are tied to primary key constraints? I've been trying to figure out the simplest way to deal with these indices.
Any comments are much appreciated.
Maria
How are people handling rebuilding indices that are tied to primary key constraints? I've been trying to figure out the simplest way to deal with these indices.
Any comments are much appreciated.
Maria