I noticed a couple of odd syntax issues today as I set up an SQL script.
1) The following does not work: ALTER SEQUENCE somesequence OWNER TO xyz; Instead you have to use: ALTER TABLE somesequence OWNER TO xyz; But if you drop a sequence the syntax is: DROP SEQUENCE somesquence; Is there a reason ALTER SEQUENCE could not have been used instead of ALTER TABLE? 2) I also noticed I cannot create a sequence targeting a particular tablespace. Example: CREATE SEQUENCE somesequence INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1 TABLESPACE xyz; Why is this? I thought that when you created a sequence you were in a sense creating a special predefined table in the background. Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu
