Re: Rookie help request

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 07 Mar 2003 14:10:17 -0800
Message-ID: <3E6918C9.F077E974@exesolutions.com>

Marcus Leon wrote:

> Hello, newbie help appreciated!
>
> Is this the correct way to alter a field to make it NOT NULL?
> ALTER TABLE TABLE_X
> MODIFY (FIELD_Y DATE NOT NULL) TABLESPACE &&abc;
>
> Is this the correct way to add an index?
> CREATE INDEX pq_idx_XYZ ON TABLE_X
> (DATE_FIELD ASC) TABLESPACE &&def;
>
> Thanks

Where did you find this syntax? Because the answer is no. There is no reason to specify a tablespace when altering a constraint.

ALTER TABLE TABLE_X
MODIFY (FIELD_Y DATE NOT NULL); and your syntax for creating an index should include the PCTFREE parameter.

You can look up valid syntax at http://tahiti.oracle.com

Daniel Morgan Received on Fri Mar 07 2003 - 16:10:17 CST