data block corruption

[SHE]

Hello to all.

I would like to ask if I drop an index with primary key, is the foreign keys attached to it will be dropped also? If so, how I can verify all the foreign keys attached to it & recreate it afterwards...

Many thanks,
she :)

[equipman]

For this matter, you will not succeed in dropping the primary key initially, as you have foreign keys attached to it. What you could do to identify the foreign keys is to run a select query to check for all tables with foreign key X, then drop the initial primary key X.

Hello to all.

I would like to ask if I drop an index with primary key, is the foreign keys attached to it will be dropped also? If so, how I can verify all the foreign keys attached to it & recreate it afterwards...

Many thanks,
she :)

[SHE]

For this matter, you will not succeed in dropping the primary key initially, as you have foreign keys attached to it. What you could do to identify the foreign keys is to run a select query to check for all tables with foreign key X, then drop the initial primary key X.

sir can you give me the commands to query all the foreign keys?

[milonov]

hi!
you can try to find tables that have foreign key to some approptiate table using query like:

select a.table_name,
a.constraint_name pkey_constraint,
a.r_constraint_name
from user_constraints a
where
a.constraint_type = 'R'
and a.r_constraint_name like '%YOUR_TABLE%'

usially r_constraint_name consists table name as part of constraint name

Best regards,
Michael Milonov,
http://www.snotratech.com

sir can you give me the commands to query all the foreign keys?

[SHE]

Sir,

I run this command & no result found.

select a.table_name,
a.constraint_name pkey_constraint,
a.r_constraint_name
from dba_constraints a
where
a.constraint_type = 'R'
and a.r_constraint_name like '%DIFFGENERICNBR%'

no rows selected

pls. advise.