on 2020 May 27 4:38 AM
I want to modify the object_id , how to modify it
update "SYS"."SYSTABCOL" set object_id=new_id where object_id=2550
The object_id is generated by SQLA when the object is created. You cannot change it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
...and why would you want to???
FWIW: Dropping and re-creating the object should lead to a different object_id.
All system tables are read only
Well, you also say you modify them via DDL, not DML..:)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.