Altering tables on Oracle NLN

Oraclenauts -

     Our DBA is trying to alter a table, adding a constraint for a primary key and creating indexes with the USING option. This is on an Oracle 7 NLN system. What happens when he tries this is that it appears to work, in that it writes a lot of blocks out to the temp tablespace, but it does not terminate. After he allows this to run all night, he is force to terminate it. It does work on some tables, the difference being that the table he is failing on has duplicate records. He is using the EXCEPTIONS INTO tablename option in his ALTER statement, but no exceptions are being generated.  

Is this a known bug? Is there a patch? Thanks in advance.  

Amy Leone Received on Mon Oct 02 1995 - 00:00:00 CET