Home » SQL & PL/SQL » SQL & PL/SQL » ora-01735
ora-01735 [message #391625] Thu, 12 March 2009 14:07 Go to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
ALTER TABLE abc
ADD CONSTRAINT abc_pk PRIMARY KEY (NUM)
TABLESPACE abc_INDEX
PCTFREE    10
INITRANS   2
MAXTRANS   255


is giving me ora-01735 error
Re: ora-01735 [message #391628 is a reply to message #391625] Thu, 12 March 2009 14:17 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
is giving me ora-01735 error

And you think we know all the error messagesby heart?
Copy and paste your SQL*Plus session.

SQL> ALTER TABLE abc
  2  ADD CONSTRAINT abc_pk PRIMARY KEY (NUM)
  3  TABLESPACE abc_INDEX
  4  PCTFREE    10
  5  INITRANS   2
  6  MAXTRANS   255
  7  /
TABLESPACE abc_INDEX
*
ERROR at line 3:
ORA-01735: invalid ALTER TABLE option

Isn't it very simple?

Your syntax is wrong, check ALTER TABLE diagram and constraint clause.

Regards
Michel
Previous Topic: sql problem
Next Topic: help needed in Collection
Goto Forum:
  


Current Time: Fri Dec 09 22:56:31 CST 2016

Total time taken to generate the page: 0.10073 seconds