Home » SQL & PL/SQL » SQL & PL/SQL » Syntax error
Syntax error [message #251192] Thu, 12 July 2007 11:34 Go to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

ALTER TABLE ORDER_ASSIGNMENT_NEW ADD(
constraint order_assignment_pknew
PRIMARY KEY
(ORDER_ASSIGNMENT_ID)
USING index ORDER_ASSIGNMENT_PK_NEW
TABLESPACE LC_MONITOR_IDX5
STORAGE(MAXEXTENTS UNLIMITED));


index ORDER_ASSIGNMENT_PK_NEW, it is unique index

Is anybody help me out, What is the syntax error in it.

Thanks in advance

[Updated on: Thu, 12 July 2007 11:34]

Report message to a moderator

Re: Syntax error [message #251193 is a reply to message #251192] Thu, 12 July 2007 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste your SQL*Plus execution.

Regards
Michel
Re: Syntax error [message #251196 is a reply to message #251193] Thu, 12 July 2007 12:09 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Oracle version 9.2.0.6.0

ORA-00907: missing right parenthesis
Re: Syntax error [message #251206 is a reply to message #251196] Thu, 12 July 2007 12:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not what I asked but thanks for this part.
Go on.

Regards
Michel
Re: Syntax error [message #251210 is a reply to message #251206] Thu, 12 July 2007 13:00 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

What is sqlplus execution ?

[Updated on: Thu, 12 July 2007 13:05]

Report message to a moderator

Re: Syntax error [message #251216 is a reply to message #251210] Thu, 12 July 2007 13:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You post this in the wrong topic.
You should think about organizing yourself when you post several topics.

Regards
Michel
Re: Syntax error [message #251255 is a reply to message #251216] Thu, 12 July 2007 14:21 Go to previous messageGo to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Never mind cool down brother.

Appreciated
Re: Syntax error [message #251258 is a reply to message #251210] Thu, 12 July 2007 14:25 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
qasim845 wrote on Thu, 12 July 2007 12:00
What is sqlplus execution ?


i guess this is
SQL> ALTER TABLE ORDER_ASSIGNMENT_NEW ADD(
constraint order_assignment_pknew
PRIMARY KEY
(ORDER_ASSIGNMENT_ID)
USING index ORDER_ASSIGNMENT_PK_NEW
TABLESPACE LC_MONITOR_IDX5
STORAGE(MAXEXTENTS UNLIMITED));  
TABLESPACE LC_MONITOR_IDX5
*
ERROR at line 6:
ORA-00907: missing right parenthesis


Re: Syntax error [message #251260 is a reply to message #251258] Thu, 12 July 2007 14:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Right!
See, Qasim, it's not difficult.

Regards
Michel
Re: Syntax error [message #251288 is a reply to message #251260] Thu, 12 July 2007 15:56 Go to previous message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Thanks alot dude Cool
Previous Topic: Sending line feed/carriage return for email body
Next Topic: ERROR - ORA-28000: the account is locked
Goto Forum:
  


Current Time: Thu Dec 08 00:34:04 CST 2016

Total time taken to generate the page: 0.11207 seconds