OraFAQ Forum: SQL & PL/SQL » Alter table and Add Constraint

Home » SQL & PL/SQL » SQL & PL/SQL » Alter table and Add Constraint

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

Alter table and Add Constraint [message #206666]

Fri, 01 December 2006 00:55

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

Hi Friends,

Its possible to add a constraint at the time of adding column..?

alter table gifterator_cart_finalimage ADD abc INTEGER NOT NULL CONSTRAINT ABC_FK FOREIGN KEY abc REFERENCES gifterator_product_details(grpd_id);

Its showing some error..

Kindly tell me the exact script..

Regards
Selva.R

Report message to a moderator

Re: Alter table and Add Constraint [message #206668 is a reply to message #206666]

Fri, 01 December 2006 00:58

Maaher
Messages: 7065
Registered: December 2001

Senior Member

selvakumar_82 wrote on Fri, 01 December 2006 07:55

Its showing some error..

Why don't you share the ORA message with us?

MHE

Report message to a moderator

Re: Alter table and Add Constraint [message #206669 is a reply to message #206668]

Fri, 01 December 2006 01:02

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

In My TOAD there is problem in showing error,

Even I am not able to find the exact message.

If you give me the exact syntax ,it will be useful...

Report message to a moderator

Re: Alter table and Add Constraint [message #206671 is a reply to message #206669]

Fri, 01 December 2006 01:04

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

What happens if you enter the same text in SQL*Plus? Does it show a specified error message then?

[Edit: and for the syntax, see the SQL reference: http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm]

[Updated on: Fri, 01 December 2006 01:05]

Report message to a moderator

Re: Alter table and Add Constraint [message #206672 is a reply to message #206671]

Fri, 01 December 2006 01:14

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

Hi,

Ok, I cant add constraint at the time of adding column....>

ORA-02253: constraint specification not allowed here

Regards
Selva.R

Report message to a moderator

Re: Alter table and Add Constraint [message #206847 is a reply to message #206672]

Fri, 01 December 2006 14:01

lunate
Messages: 74
Registered: October 2006
Location: Pakistan

Member

my be ENTERPRISE MANAGER CONSOLE can solve your problem.

Report message to a moderator

Re: Alter table and Add Constraint [message #206850 is a reply to message #206847]

Fri, 01 December 2006 14:35

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I thought that there's no console which can solve invalid syntax problems.

Report message to a moderator

Re: Alter table and Add Constraint [message #206944 is a reply to message #206850]

Sat, 02 December 2006 10:44

lunate
Messages: 74
Registered: October 2006
Location: Pakistan

Member

MAY BE U DON'T EVER PAY ATTENTION TO YOUR CONSOLE (LITTLE FOOT)

I DO THIS MANY TIME .PLEASE C CARE FULLY YOUR CONSOLE MANAGER .

REGARDS

Report message to a moderator

Re: Alter table and Add Constraint [message #206949 is a reply to message #206944]

Sat, 02 December 2006 11:25

Frank
Messages: 7901
Registered: March 2000

Senior Member

The original poster used invalid syntax. Littlefoot pointed out that invalid syntax stays invalid syntax, regardless of the tool you use!

(Your keyboard is stuck. Not only do all letters come out in capitals (maybe give the old capslock a good hit?), but there also appear to be some keys missing.)

Report message to a moderator