Flashback Data Archive

Tom LieberTom Lieber
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