Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem with dropping a Primary Key and his Index on Oracle 10R1

Problem with dropping a Primary Key and his Index on Oracle 10R1

From: A. Peters <info_no_spam_at_ap-data.de>
Date: Sun, 5 Feb 2006 13:39:16 +0100
Message-ID: <ds4rld$5di$02$1@news.t-online.com>

Hello!
I´ve a Problem with Oracle 10 R1 and need some help. I have installed a Oracle 10 R1 on a Testsystem and imported a Databaseuser (with Tables etc...)

now i want to update the structure of a table and droped the Primary Key and oracle dropped the pk. But he doesnt dropped the INDEX from the Primary Key. He leaves them on the column.

when i create a Primary Key for a table on Oracle 10 R1 and drop the Primary key the index is dropped to.
That he doesn´t drop the INDEX happend only when the primary key is created on a previous Version of Oracle
like Oracle 8 or Oracle 9.

I need to solve the problem, because we have customers with differenz Oracle Versions and all shoudt get the
some SQL Statements to update her Database Structure.

Greetings
A. Peters

-- 
Received on Sun Feb 05 2006 - 06:39:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US