Hi I am using Oracle 12C.
There is a table for which the primary key column is getting populated from a sequence as below.
The primary key ACCTTYPETXTID is getting populated from "CUCIFS"."SEQ_ACCOUNTTYPETXT"."NEXTVAL" . Is it possible to update to "User1"."SEQ_ACCOUNTTYPETXT"."NEXTVAL"
The DB version is 12c R2.
CREATE TABLE "CUCCP8"."ACCOUNTTYPETXT"
( "DESCRIPTION" VARCHAR2(255 CHAR),
"TXTLANGUAGE" CHAR(2 CHAR) NOT NULL ENABLE,
"ACCTTYPEID" NUMBER(20,0),
"ACCTTYPETXTID" NUMBER DEFAULT ON NULL "CUCIFS"."SEQ_ACCOUNTTYPETXT"."NEXTVAL" NOT NULL ENABLE,
CONSTRAINT "PK_ACCOUNTTYPETXT" PRIMARY KEY ("ACCTTYPETXTID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_P8D1" ENABLE,
CONSTRAINT "UQ_ACCOUNTTYPETXT" UNIQUE ("ACCTTYPEID", "TXTLANGUAGE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_P8D1" ENABLE,
CONSTRAINT "FK66KF76V8UIIIY8PIX65YH09CL" FOREIGN KEY ("ACCTTYPEID")
REFERENCES "CUCCP8"."ACCOUNTTYPE" ("ACCTTYPEID") ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TS_P8D1" ;