Database Administration (MOSC)

MOSC Banner

What is the best way to add new field to an existing Primary Key?

edited Jun 13, 2012 4:03PM in Database Administration (MOSC) 4 comments
 Hi All,    I have a situation which need to add a new field to an existing primary key. The table rows is around 3 millions. The only way I know to do this is

- drop primary key
- re create the primary key with adding new field

but my concern is that the rows contain 3 millions rows. Is there a way to estimate how long it will take to perform this changes ?

Rgrds
Ezree

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center