Hi,

I am trying to add a primary key on a table that has got 30 million records .

Here is my sql :
alter table tableA add constraint pk_tableA
primary key (col1,col2) using index tablespace tablespaceA;

this job is not completeing has been running last two hours and not finishing yet .

In v$session this session is active but i am not able find the
sql_text from v$sqltext .

Could any one can tell how will i make sure this sql is creating the primary key or not ?

Thanks
tom