Re: Altering tables on Oracle NLN

From: Mike Redford <sg92nmwj_at_dunx1.ocs.drexel.edu>
Date: 1995/10/18
Message-ID: <463g43$5st_at_noc2.drexel.edu>#1/1


Amy Leone (amyleone_at_nyc.pipeline.com) wrote:
: 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



You should change your specification of the index. Remember that if duplicate is involved, then the function will never work on neither unique indexing or cluster indexing.

azubike Received on Wed Oct 18 1995 - 00:00:00 CET

Original text of this message