OraFAQ Forum: Server Administration » Drop Master Detail Table

Home » RDBMS Server » Server Administration » Drop Master Detail Table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Drop Master Detail Table [message #312385]

Tue, 08 April 2008 13:42

ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai

Senior Member

I have created one master table and a detail table which references the primary column of the master table.

Now i dropped the master table then i want to drop the detail table is it possible?

I tried but it gives error an
A-02449: unique/primary keys in table referenced by foreign keys

How can i rectify this by not create master table again

Report message to a moderator

Re: Drop Master Detail Table [message #312386 is a reply to message #312385]

Tue, 08 April 2008 13:45

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Your detail table is a master for another one.

Regards
Michel

[Updated on: Tue, 08 April 2008 13:45]

Report message to a moderator

Re: Drop Master Detail Table [message #312388 is a reply to message #312386]

Tue, 08 April 2008 13:48

ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai

Senior Member

Thanks Michel

Report message to a moderator

Re: Drop Master Detail Table [message #312390 is a reply to message #312385]

Tue, 08 April 2008 13:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ORAGENASHOK,

why do you refuse to follow posting guidelines?

[Updated on: Tue, 08 April 2008 13:51] by Moderator

Report message to a moderator

Re: Drop Master Detail Table [message #312548 is a reply to message #312390]

Wed, 09 April 2008 03:59

ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai

Senior Member

No

Report message to a moderator

Re: Drop Master Detail Table [message #312559 is a reply to message #312548]

Wed, 09 April 2008 04:35

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No?

/forum/fa/1600/0/

No for what?

Regards
Michel

Report message to a moderator

Previous Topic:	startup mount
Next Topic:	csscan report advice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 06 16:54:21 CDT 2024