Flashback Data Archive

dbms_metadata Bug?

·

1 min read

Export as DDL: via dbms_metadata

Oracle 19c. SE

CREATE TABLE "TEST" ("TEST" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 43277 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE , "MANDANT" VARCHAR2(200 CHAR) DEFAULT 'TEST', "TEST_OID" NUMBER, "TESTA_OID" NUMBER ) ;

ALTER TABLE "TEST" FLASHBACK ARCHIVE "FBA_DATA"

Missing TERMINATION Character ;