Flashback Data Archive

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 ;
0
Subscribe to my newsletter
Read articles from Tom Lieber directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by

Tom Lieber
Tom Lieber
Databaseguy, Oracle Apex Lover