Skip to main content

Command Palette

Search for a command to run...

Flashback Data Archive

dbms_metadata Bug?

Published
•1 min read•View as Markdown
T

Databaseguy, Oracle Apex Lover

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 ;

TL:DR;

Part 10 of 16

Collect stuff which is not that important for an end-user

Up next

Oracle Ace Program

I AM IN