Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Question Unanswered: deleted primary key

    hi,

    I had dropped a table which had a primary key index. When I recovered it using flashback, the table got recovered. Primary key has also been recovered but with the name BIN$Hyx0mxWUJUHgRAADul0Z8w==$0. Now, when I see the status in user_indexes, it shows unusable.

    If i try to drop this index using the command
    drop index BIN$Hyx0mxWUJUHgRAADul0Z8w==$0, it gives an error.

    I even tried dropping it using :
    alter table emp drop constraint BIN$Hyx0mxWUJUHgRAADul0Z8w==$0

    But this also does not work.

    My problem is that I want to remove it and create a new primary key on my table. Please tell me how to solve this problem.

    Regards,
    Radhika

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Did you try: ALTER TABLE theTable DROP PRIMARY KEY

  3. #3
    Join Date
    Jul 2007
    Posts
    2
    Thanx a lot Shammat. It worked.

    Regards,
    Radhika

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •