r12.2 noneditioned objects

[Sri]

Hi erman,

Need your help.

Our developer asked to create a sequence on custom table as below

CREATE SEQUENCE XXMOT.XXMOT_INV_ARQ_SET
  START WITH 1
  MAXVALUE 99999999999
  MINVALUE 1
  NOCYCLE
  CACHE 20
  NOORDER  

can we create it directly on custom table in R2.2?
do we need to create any synonym for this?

Thanks

[ErmanArslansOracleBlog]

There is no standard for Sequences.

Just the following standard apply:

Do not alter a sequence in a way that is incompatible with the running application.
Do not drop a sequence until the cleanup phase of patch execution.

[Sri]

Actually we are creating above sequence in run edition.i am confused if we can create directly on customuser.tablename

[ErmanArslansOracleBlog]

As I said, no documented restrictions for sequences..
You can create custom sequences on your custom tables.