-- Create Table
create table debezium.products (id NUMBER(4) GENERATED BY DEFAULT ON NULL AS IDENTITY (START WITH 101) NOT NULL PRIMARY KEY, name VARCHAR2(255) NOT NULL, description VARCHAR2(512), weight FLOAT);
create table debezium.products (id NUMBER(4) GENERATED BY DEFAULT ON NULL AS IDENTITY (START WITH 101 INCREMENT BY 1 CYCLE CACHE 200) NOT NULL PRIMARY KEY, name VARCHAR2(255) NOT NULL, description VARCHAR2(512), weight FLOAT);
create global temporary table sys.ora_temp_1_ds_1550399 sharing=none on commit preserve rows cache noparallel as select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false') no_substrb_pad */"ENTRYUUID", rowid SYS_DS_ALIAS_0 from "IDENTITYDB"."OAUTH2_CLIENT_CHANGE_LOGS" sample ( 10.0000000000) t WHERE 1 = 2;
CREATE TABLE "ABCD_SHARD_1_3"."D_PLAN_SCHEDULE_LOT_ENTRY"("ID" NUMBER(38,0) NOT NULL ENABLE, "LOT_ID" NUMBER(38,0) NOT NULL ENABLE, "PLAN_SCHEDULE_ID" NUMBER(38,0) NOT NULL ENABLE, "IS_ACTUAL" NUMBER(1,0) NOT NULL ENABLE, "OOS_POSITION_NUMBER" NVARCHAR2(50) DEFAULT 0, CONSTRAINT "PK_PSLE_ENTRY_ID" PRIMARY KEY ("ID") USING INDEX  ENABLE, SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS, SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS, SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS, CONSTRAINT "FK_PSLE_LOT_VERSION" FOREIGN KEY ("LOT_ID") REFERENCES "ABCD_SHARD_1_3"."D_LOT_VERSION" ("ID") DISABLE, CONSTRAINT "FK_PSLE_PLAN_SCHEDULE_VERSION" FOREIGN KEY ("PLAN_SCHEDULE_ID") REFERENCES "ABCD_SHARD_1_3"."D_PLAN_SCHEDULE_VERSION" ("ID") ENABLE );
CREATE TABLE IDATA_BAIIR.CUST_INFO (ID NUMBER(20) NOT NULL ENABLE, CUST_NAME VARCHAR2(200 CHAR) NOT NULL ENABLE, CUST_NAME_PY VARCHAR2(500 CHAR), CUST_NAME_PY_SZ VARCHAR2(50 CHAR), CUST_NAME_ABBR VARCHAR2(100 CHAR), CUST_NAME_ABBR_PY VARCHAR2(300 CHAR), CUST_NAME_ABBR_PY_SZ VARCHAR2(50 CHAR), CUST_NAME_EN VARCHAR2(100 CHAR), CUST_TYPE NUMBER(10), CUST_STATUS NUMBER(10), CUST_LEVEL NUMBER(10), MEMO VARCHAR2(500 CHAR), TEL_NUM VARCHAR2(100 CHAR), FAX_NUM VARCHAR2(100 CHAR), INTERNET_ADDRESS VARCHAR2(200 CHAR), COMPANY_ADDRESS VARCHAR2(200 CHAR), POST_CODE VARCHAR2(50 CHAR), EMAIL_ADDRESS VARCHAR2(200 CHAR), CUST_VALID_FLAG NUMBER(1), EXP_DATE DATE, CERT_TYPE NUMBER(10), CERT_NUM VARCHAR2(100 CHAR), CERT_CUST_NAME VARCHAR2(200 CHAR), RISK_LEVEL NUMBER(10), FXPP_CONFIRM_PROCESS NUMBER(10), FXPP_CONFIRM_PROCESS_INFO NUMBER(10), SDX_INFO_AUDITOR VARCHAR2(100 CHAR), SDX_NEW_COM NUMBER(1), ECIF_OTC_FLAG NUMBER(1), AUDIT_STATUS NUMBER(1), IS_VALID NUMBER(1) DEFAULT 1 NOT NULL ENABLE, CREATE_TIME DATE, CREATOR NUMBER(20), CREATOR_NAME VARCHAR2(30 CHAR), MODIFY_TIME DATE, MODIFIER NUMBER(20), MODIFIER_NAME VARCHAR2(30 CHAR)) tablespace BIGDATADBT pctfree 10 initrans 1 maxtrans 255 storage ( initial 192K next 1M minextents 1 maxextents unlimited );
create table dbz1211 (id number(38) not null, data varchar2(50), constraint name primary key (id) using index tablespace ts1) tablespace ts2;
CREATE TABLE "HR"."COUNTRIES"( "COUNTRY_ID" CHAR(2) CONSTRAINT "COUNTRY_ID_NN" NOT NULL ENABLE,"COUNTRY_NAME" VARCHAR2(40),"REGION_ID" NUMBER,CONSTRAINT "COUNTRY_C_ID_PK" PRIMARY KEY ("COUNTRY_ID") ENABLE,SUPPLEMENTAL LOG DATA (ALL) COLUMNS,CONSTRAINT "COUNTR_REG_FK" FOREIGN KEY ("REGION_ID")REFERENCES "HR"."REGIONS" ("REGION_ID") ENABLE) ORGANIZATION INDEX NOCOMPRESS;
CREATE TABLE "VELEBIT_ZAVAR_PROD"."PON_PRIJENOS" ("SIF_AGENCIJE" NUMBER DEFAULT 0 NOT NULL ENABLE, "DAT_PRIJENOSA" DATE NOT NULL ENABLE, "VRS_POLICE" NUMBER DEFAULT 0 NOT NULL ENABLE, "BR_ZAPRIMLJENIH" NUMBER DEFAULT 0, "BR_POLICIRANIH" NUMBER DEFAULT 0) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ROW STORE COMPRESS ADVANCED 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_VELEBIT" PARALLEL 8 ;
create table eshp_auction_file_history (history_id number not null, history_date timestamp not null, auction_id number not null, changed_by varchar(4000), type varchar(4000) not null, constraint pk_eshp_auction_file_history primary key (history_id) using index (create unique index idx_eshp_auction_file_history_id on eshp_auction_file_history(history_id)), constraint fk_eshp_auc_file_history_auction foreign key (auction_id) references eshp_auction(auction_id) on delete cascade);
CREATE TABLE "IDENTITYDB"."CHANGE_NUMBERS" ( "CHANGE_NO" NUMBER(*,0) NOT NULL ENABLE, "SOURCE_INFO" VARCHAR2(128) NOT NULL ENABLE, "CHANGED_TIME" TIMESTAMP (6) DEFAULT SYSDATE, "ENTITY_TYPE" VARCHAR2(36) NOT NULL ENABLE, "ORGANIZATIONID" VARCHAR2(36), "PROCESSED" NUMBER(1,0) DEFAULT 1 NOT NULL ENABLE, "TRACKING_ID" VARCHAR2(256) NOT NULL ENABLE, "EXPIRY_TIME" TIMESTAMP (6), "ACTOR" VARCHAR2(36), "ENTITY_ID" VARCHAR2(36) ) PARTITION BY RANGE ("EXPIRY_TIME") INTERVAL (NUMTODSINTERVAL(7, 'DAY')) SUBPARTITION BY HASH ("CHANGE_NO") SUBPARTITIONS 16 (PARTITION "SYS_P44414"  VALUES LESS THAN (TIMESTAMP' 2021-07-06 00:00:00') ( SUBPARTITION "SYS_SUBP44398" , SUBPARTITION "SYS_SUBP44399" , SUBPARTITION "SYS_SUBP44400" , SUBPARTITION "SYS_SUBP44401" , SUBPARTITION "SYS_SUBP44402" , SUBPARTITION "SYS_SUBP44403" , SUBPARTITION "SYS_SUBP44404" , SUBPARTITION "SYS_SUBP44405" , SUBPARTITION "SYS_SUBP44406" , SUBPARTITION "SYS_SUBP44407" , SUBPARTITION "SYS_SUBP44408" , SUBPARTITION "SYS_SUBP44409" , SUBPARTITION "SYS_SUBP44410" , SUBPARTITION "SYS_SUBP44411" , SUBPARTITION "SYS_SUBP44412" , SUBPARTITION "SYS_SUBP44413" ) );
CREATE TABLE "ETUDES"."IMPORT_EXMETI" (abort_step NUMBER,access_method VARCHAR2(16),ancestor_object_name VARCHAR2(128),ancestor_object_schema VARCHAR2(128),ancestor_object_type VARCHAR2(128),ancestor_process_order NUMBER,base_object_name VARCHAR2(128),base_object_schema VARCHAR2(128),base_object_type VARCHAR2(128),base_process_order NUMBER,block_size NUMBER,cluster_ok NUMBER,completed_bytes NUMBER,completed_rows NUMBER,completion_time DATE,control_queue VARCHAR2(128),creation_level NUMBER,creation_time DATE,cumulative_time NUMBER,data_buffer_size NUMBER,data_io NUMBER,dataobj_num NUMBER,db_version VARCHAR2(60),degree NUMBER,domain_process_order NUMBER,dump_allocation NUMBER,dump_fileid NUMBER,dump_length NUMBER,dump_orig_length NUMBER,dump_position NUMBER,duplicate NUMBER,elapsed_time NUMBER,error_count NUMBER,extend_size NUMBER,file_max_size NUMBER,file_name VARCHAR2(4000),file_type NUMBER,flags NUMBER,grantor VARCHAR2(128),granules NUMBER,guid RAW(16),in_progress CHAR(1),instance VARCHAR2(60),instance_id NUMBER,is_default NUMBER,job_mode VARCHAR2(21),job_version VARCHAR2(60),last_file NUMBER,last_update DATE,load_method NUMBER,metadata_buffer_size NUMBER,metadata_io NUMBER,name VARCHAR2(128),object_int_oid VARCHAR2(130),object_long_name VARCHAR2(4000),object_name VARCHAR2(200),object_number NUMBER,object_path_seqno NUMBER,object_row NUMBER,object_schema VARCHAR2(128),object_tablespace VARCHAR2(128),object_type VARCHAR2(128),object_type_path VARCHAR2(200),objnum NUMBER,old_value VARCHAR2(4000),operation VARCHAR2(8),option_tag VARCHAR2(128),orig_base_object_name VARCHAR2(128),orig_base_object_schema VARCHAR2(128),original_object_name VARCHAR2(128),original_object_schema VARCHAR2(128),packet_number NUMBER,parallelization NUMBER,parent_object_name VARCHAR2(128),parent_object_schema VARCHAR2(128),parent_process_order NUMBER,partition_name VARCHAR2(128),phase NUMBER,platform VARCHAR2(101),process_name VARCHAR2(128),process_order NUMBER,processing_state CHAR(1),processing_status CHAR(1),property NUMBER,proxy_schema VARCHAR2(128),proxy_view VARCHAR2(128),queue_tabnum NUMBER,remote_link VARCHAR2(128),scn NUMBER,seed NUMBER,service_name VARCHAR2(64),size_estimate NUMBER,src_compat VARCHAR2(60),start_time DATE,state VARCHAR2(12),status_queue VARCHAR2(128),subpartition_name VARCHAR2(128),target_xml_clob CLOB,tde_rewrapped_key RAW(2000),template_table VARCHAR2(128),timezone VARCHAR2(64),total_bytes NUMBER,trigflag NUMBER,unload_method NUMBER,user_directory VARCHAR2(4000),user_file_name VARCHAR2(4000),user_name VARCHAR2(128),value_n NUMBER,value_t VARCHAR2(4000),version NUMBER,work_item VARCHAR2(21),xml_clob CLOB,xml_process_order NUMBER) SEGMENT CREATION IMMEDIATE NO INMEMORY INITRANS 100;
CREATE TABLE "IFSAPP".CMP4$94648 organization heap tablespace "IFSAPP_DATA" compress for all operations nologging as select /*+ DYNAMIC_SAMPLING(0) */ * from "IFSAPP".COMP3$94648 mytab;
CREATE TABLE "ZZJOBRUN_MDE" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "REPID" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "VARNA" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "ZZ_MDE_INFO" VARCHAR2 (000075) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3TBLS NOCOMPRESS NO INMEMORY STORAGE (INITIAL 0000000064 K NEXT 0000001024 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01);
CREATE TABLE "DEBEZIUM"."TYPE_GEOMETRY" ( "ID" NUMBER(9,0) NOT NULL ENABLE, "LOCATION" "SDO_GEOMETRY", PRIMARY KEY ("ID") USING INDEX ENABLE, SUPPLEMENTAL LOG DATA (ALL) COLUMNS ) VARRAY "LOCATION"."SDO_ELEM_INFO" STORE AS SECUREFILE LOB VARRAY "LOCATION"."SDO_ORDINATES" STORE AS SECUREFILE LOB;
CREATE TABLE "U3"."TEST_QUEUE_TABLE"(q_name            VARCHAR2(128),msgid              RAW(16),corrid             VARCHAR2(128),priority           NUMBER,state              NUMBER,delay              TIMESTAMP,expiration         NUMBER,time_manager_info  TIMESTAMP,local_order_no     NUMBER,chain_no           NUMBER,cscn               NUMBER,dscn               NUMBER,enq_time           TIMESTAMP,enq_uid             VARCHAR2(128), enq_tid            VARCHAR2(30),deq_time           TIMESTAMP,deq_uid             VARCHAR2(128), deq_tid            VARCHAR2(30),retry_count        NUMBER,exception_qschema  VARCHAR2(128),exception_queue    VARCHAR2(128),step_no            NUMBER,recipient_key      NUMBER,dequeue_msgid      RAW(16),sender_name    VARCHAR2(128),sender_address VARCHAR2(1024),sender_protocol NUMBER,USER_DATA "SYS"."AQ$_JMS_TEXT_MESSAGE",user_prop      SYS.ANYDATA, PRIMARY KEY(msgid) ) USAGE QUEUE ;
create table products (id NUMBER(4) NOT NULL PRIMARY KEY, name VARCHAR2(255) NOT NULL, seq NUMBER NOT NULL);
CREATE TABLE T$BO_PATIENT_LMAP NOLOGGING TABLESPACE CMX_TEMP_TDE PARALLEL (DEGREE 1) AS SELECT DISTINCT XREF.ORIG_ROWID_OBJECT, XREF.ROWID_OBJECT FROM C_S_PATIENT STAGE INNER JOIN C_BO_PATIENT_XREF XREF ON XREF.ORIG_ROWID_OBJECT = STAGE.ROWID_OBJECT WHERE STAGE.ROWID_OBJECT IS NOT NULL ;
CREATE TABLE "ORACDC"."DEPARTMENT"  (    "EMP_NO" VARCHAR2(20) NOT NULL ENABLE, "REQUEST_ID" VARCHAR2(30) NOT NULL ENABLE, "EMP_RCODE" NUMBER(2,0), "EMP_RFLAG" VARCHAR2(20), "EMP_RMSG" VARCHAR2(1000), "EMP_EMP_AMOUNT" NUMBER(8,2), "EMP_EMP_AVS" VARCHAR2(20), "EMP_EMP_CODE" VARCHAR2(200), "EMP_EMP_TIME" VARCHAR2(20), "LAST_UPD_DATE" DATE, "LAST_UPD_BY" VARCHAR2(20), "SITE_ID" NUMBER(5,0) DEFAULT NULL NOT NULL ENABLE, "OBSOLETE_FLAG" CHAR(1) DEFAULT 'N' NOT NULL ENABLE, "PRODUCT_TYPE_ID" NUMBER DEFAULT 2, "TRX_NUMBER" VARCHAR2(30), "RECONCILIATION_ID" VARCHAR2(60), "REQUEST_TOKEN" VARCHAR2(256), "LOAD_TIMESTAMP" TIMESTAMP (6), "PAYMENT_TYPE" VARCHAR2(50), "TRANSACTION_SOURCE" VARCHAR2(50), "CREDIT_CARD_TYPE" VARCHAR2(50),  SUPPLEMENTAL LOG GROUP "GGS_19282" ("EMP_NO", "REQUEST_ID") ALWAYS, SUPPLEMENTAL LOG DATA (ALL) COLUMNS, CONSTRAINT "DEPARTMENT_FK" FOREIGN KEY ("EMP_NO")   REFERENCES "ORACDC"."MEM_REG" ("EMP_NO") ENABLE NOVALIDATE  ) PARTITION BY HASH ("EMP_NO") (PARTITION "DEPARTMENT_P1" ,PARTITION "DEPARTMENT_P2" , PARTITION "DEPARTMENT_P32" );
CREATE TABLE "ODS_XMES_QY"."ORDER" ("Oid" CHAR(36), "CONTRACT" CHAR(36), CONSTRAINT "PK_ORDER" PRIMARY KEY ("Oid") USING INDEX ENABLE, SUPPLEMENTAL LOG GROUP "GGS_87678" ("Oid") ALWAYS) INMEMORY PRIORITY CRITICAL MEMCOMPRESS FOR QUERY LOW DISTRIBUTE AUTO FOR SERVICE ALL NO DUPLICATE;
CREATE TABLE tab (ID number(9) primary key, data xmltype, data2 xmltype);
CREATE TABLE test9 ( doc mdsys.sdo_geometry );
  CREATE TABLE "XMES"."ORDER_ITEM"
   (    "CREATE_TIME" DATE,
    "Oid" CHAR(36) NOT NULL ENABLE,
    "ORDER" CHAR(36),
    "ORDER_PRODUCT" CHAR(36),
    "JOB_HEAD" CHAR(36),
    "NAME" NVARCHAR2(100),
    "STD_CODE" NVARCHAR2(50),
    "STD_ITEM_NAME" NVARCHAR2(50),
    "STD_TYPE" NUMBER(*,0),
    "NON_STD" NUMBER(1,0),
    "OWE_MTL" NUMBER(1,0),
    "NON_STD_ITEM_CODE" NVARCHAR2(50),
    "ITEM_CLASSIFY" CHAR(36),
    "Parent" CHAR(36),
    "ITEMID" NVARCHAR2(50),
    "STANDARD_MODEL" NUMBER(1,0),
    "ITEMCODE" NVARCHAR2(50),
    "TYPE" NVARCHAR2(10),
    "PART_TYPE" NVARCHAR2(100),
    "LINE_NO" NVARCHAR2(30),
    "OTHER_NAME" NVARCHAR2(500),
    "LENGTH" FLOAT(126),
    "FLENGTH" FLOAT(126),
    "WIDTH" FLOAT(126),
    "FWIDTH" FLOAT(126),
    "THICKNESS" FLOAT(126),
    "FTHICKNESS" FLOAT(126),
    "QTY_OLD" NUMBER(*,0),
    "UOM" NVARCHAR2(10),
    "BARCODE" NVARCHAR2(50),
    "PURCHASE_ID" NVARCHAR2(100),
    "DESCRIPTION1" NVARCHAR2(1000),
    "DESCRIPTION2" NVARCHAR2(1000),
    "ISPEC" NUMBER(*,0),
    "GRID" NUMBER(1,0),
    "GROR" NUMBER(1,0),
    "NGRID" NUMBER(*,0),
    "SURFTGRID" NUMBER(*,0),
    "EDGE_ID" NUMBER(*,0),
    "EDGE_INFO" NVARCHAR2(800),
    "WEIGHT" FLOAT(126),
    "ID_TEXT" NVARCHAR2(500),
    "CNC_FLAG" NUMBER(1,0),
    "BOM_FLAG" NUMBER(1,0),
    "EXCEPTION" NUMBER(1,0),
    "IS_SUPPLY" NUMBER(1,0),
    "CUT_FLAG" NUMBER(1,0),
    "ASSOC_PART" NVARCHAR2(50),
    "INFO2" NVARCHAR2(100),
    "INFO3" NVARCHAR2(600),
    "INFO4" NVARCHAR2(100),
    "INFO5" NVARCHAR2(400),
    "COLOR" NVARCHAR2(100),
    "SURFT_ID" NVARCHAR2(50),
    "SURFT_NAME" NVARCHAR2(100),
    "SURFT_K3_CODE" NVARCHAR2(50),
    "SURFT_MTL_TYPE" NVARCHAR2(100),
    "SURFB_ID" NVARCHAR2(50),
    "SURFB_NAME" NVARCHAR2(100),
    "SURFB_K3_CODE" NVARCHAR2(50),
    "SURFB_MTL_TYPE" NVARCHAR2(100),
    "MTL_LIST_DATE" DATE,
    "TO_JOB" NUMBER(1,0),
    "VIRTUAL" NUMBER(1,0),
    "MTL_TYPE" NVARCHAR2(100),
    "PACKED" NUMBER(1,0),
    "SUPPLIER" NVARCHAR2(200),
    "INFO6" NVARCHAR2(800),
    "TMP_ROAD" NVARCHAR2(2000),
    "ORDER_ITEM_PROD_INFO" CHAR(36),
    "DOOR_DIR" NVARCHAR2(50),
    "IS_MANUAL_DECOMPOSE" NUMBER(1,0),
    "MMP" NUMBER(1,0),
    "AUTO_ID" NUMBER(20,0),
    "PACK_TYPE" NVARCHAR2(100),
    "MTL_RULE" CHAR(36),
    "SURFT_NAM" NVARCHAR2(100),
    "MAT_NAM" NVARCHAR2(100),
    "MAT_ID" NVARCHAR2(100),
    "OPERATION_ROAD" NVARCHAR2(2000),
    "OLD_TECH_CODE" NVARCHAR2(100),
    "PARENT_PROPERTY" NVARCHAR2(100),
    "ENGLISH_NAME" NVARCHAR2(100),
    "REPORTLOSS_TYPE" NVARCHAR2(100),
    "INACTIVE" NUMBER(1,0),
    "LACK_ADD_NOTE" NVARCHAR2(500),
    "OptimisticLockField" NUMBER(*,0),
    "TABLE_TASK_COMPLETE" NUMBER(1,0),
    "ADJUST_STOCK" NVARCHAR2(100),
    "CRAFT_BATCH" NVARCHAR2(100),
    "GLASS_NAME" NVARCHAR2(100),
    "SUPPLY_TYPE" NVARCHAR2(20),
    "AUTO_PICK" NUMBER(1,0),
    "QTY" NUMBER(20,2),
    "XML_ANALYSIS" NCLOB,
     CONSTRAINT "PK_ORDER_ITEM" PRIMARY KEY ("Oid")
  USING INDEX  ENABLE,
     SUPPLEMENTAL LOG DATA (ALL) COLUMNS,
     CONSTRAINT "FK_ORDER_ITEM_ORDER" FOREIGN KEY ("ORDER")
      REFERENCES "XMES"."ORDER" ("Oid") ENABLE,
     CONSTRAINT "FK_ORDER_ITEM_ORDER_PRODUCT" FOREIGN KEY ("ORDER_PRODUCT")
      REFERENCES "XMES"."ORDER_PRODUCT" ("Oid") ENABLE,
     CONSTRAINT "FK_ORDER_ITEM_JOB_HEAD" FOREIGN KEY ("JOB_HEAD")
      REFERENCES "XMES"."JOB_HEAD" ("Oid") ENABLE,
     CONSTRAINT "FK_ORDER_ITEM_ITEM_CLASSIFY" FOREIGN KEY ("ITEM_CLASSIFY")
      REFERENCES "XMES"."ITEM_CLASSIFY_RULE" ("Oid") ENABLE,
     CONSTRAINT "FK_ORDER_ITEM_Parent" FOREIGN KEY ("Parent")
      REFERENCES "XMES"."ORDER_ITEM" ("Oid") ENABLE,
     CONSTRAINT "FK_ORDER_ITEM_ORDER_I_DB670C25" FOREIGN KEY ("ORDER_ITEM_PROD_INFO")
      REFERENCES "XMES"."ORDER_ITEM_PROD_INFO" ("Oid") ENABLE,
     CONSTRAINT "FK_ORDER_ITEM_MTL_RULE" FOREIGN KEY ("MTL_RULE")
      REFERENCES "XMES"."MTL_RULE" ("Oid") ENABLE
   )
  PARTITION BY RANGE ("CREATE_TIME")
 (PARTITION "FOURTH2018"  VALUES LESS THAN (TO_DATE(' 2019-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "FIRST2019"  VALUES LESS THAN (TO_DATE(' 2019-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "SECOND2019"  VALUES LESS THAN (TO_DATE(' 2019-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "THIRD2019"  VALUES LESS THAN (TO_DATE(' 2019-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "FOURTH2019"  VALUES LESS THAN (TO_DATE(' 2020-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "FIRST2020"  VALUES LESS THAN (TO_DATE(' 2020-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "SECOND2020"  VALUES LESS THAN (TO_DATE(' 2020-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "THIRD2020"  VALUES LESS THAN (TO_DATE(' 2020-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "FOURTH2020"  VALUES LESS THAN (TO_DATE(' 2021-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "FIRST2021"  VALUES LESS THAN (TO_DATE(' 2021-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "SECOND2021"  VALUES LESS THAN (TO_DATE(' 2021-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "THIRD2021"  VALUES LESS THAN (TO_DATE(' 2021-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ,
 PARTITION "OTHER"  VALUES LESS THAN (MAXVALUE) ) ;
-- Create External Table
CREATE TABLE deptXTec3
    ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY def_dir1
                            ACCESS PARAMETERS (COMPRESSION ENABLED)
                            LOCATION ('dept.dmp'));

CREATE TABLE inv_part_all_xt (PRODUCT_ID NUMBER(6), WAREHOUSE_ID NUMBER(3), QUANTITY_ON_HAND NUMBER(8))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY def_dir1
                            ACCESS PARAMETERS (COMPRESSION ENABLED)
                            LOCATION ('inv_p1_xt.dmp','inv_p2_xt.dmp'));

CREATE TABLE emp_load (first_name CHAR(15), last_name CHAR(20), resume CHAR(2000), picture RAW (2000))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_tab_dir
                            ACCESS PARAMETERS (FIELDS (first_name VARCHARC(5,12), last_name VARCHARC(2,20), resume VARCHARC(4,10000), picture VARRAWC(4,100000)))
                            LOCATION ('info.dat'));

CREATE TABLE emp_load (first_name CHAR(15), last_name CHAR(20), resume CHAR(2000), picture RAW (2000))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_tab_dir
                            ACCESS PARAMETERS ( RECORDS VARIABLE 2 DATA IS BIG ENDIAN CHARACTERSET US7ASCII
                                                FIELDS (first_name VARCHAR(2,12), last_name VARCHAR(2,20), resume VARCHAR(4,10000), picture VARRAW(4,100000)))
                            LOCATION ('info.dat'));

CREATE TABLE emp_load (first_name CHAR(15), last_name CHAR(20), year_of_birth INT, phone CHAR(12), area_code CHAR(3), exchange CHAR(3), extension CHAR(4))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_tab_dir
                            ACCESS PARAMETERS ( FIELDS RTRIM (first_name (1:15) CHAR(15), last_name (*:+20), year_of_birth (36:39), phone (40:52), area_code (*-12: +3), exchange (*+1: +3), extension (*+1: +4)))
                            LOCATION ('info.dat'));

CREATE TABLE emp_load (first_name CHAR(15), last_name CHAR(20), year_of_birth CHAR(4))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_tab_dir
                            ACCESS PARAMETERS ( FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '(' and ')' LRTRIM )
                            LOCATION ('info.dat'));

CREATE TABLE xtab (recno varchar2(2000))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY data_dir
                            ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE
                                                PREPROCESSOR execdir:'zcat'
                                                LOGFILE 'deptxt1.log'
                                                BADFILE 'deptXT.bad'
                                                FIELDS TERMINATED BY ',' MISSING FIELD VALUES ARE NULL (recno char(2000)))
                            LOCATION ('foo.dat.gz')) REJECT LIMIT UNLIMITED;

CREATE TABLE deptxt1 ( deptno number(2), dname varchar2(14), loc varchar2(13))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY dpump_dir
                            ACCESS PARAMETERS ( EXTERNAL VARIABLE DATA
                                               LOGFILE 'deptxt1.log'
                                               READSIZE=10000
                                               PREPROCESSOR execdir:'uncompress.sh' )
                            LOCATION ('deptxt1.dmp')) REJECT LIMIT UNLIMITED;

CREATE TABLE "T_XT" ("C0" VARCHAR2(2000))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY DMPDIR
                            ACCESS PARAMETERS ( RECORDS XMLTAG ("home address", "work address", "home phone")
                                                READSIZE 1024
                                                SKIP 0
                                                FIELDS NOTRIM MISSING FIELD VALUES ARE NULL)
                            LOCATION ('t.dat')) REJECT LIMIT UNLIMITED;

CREATE TABLE emp_load (first_name CHAR(15), last_name CHAR(20), year_of_birth CHAR(4))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_tab_dir
                            ACCESS PARAMETERS ( RECORDS DELIMITED BY '|' FIELDS TERMINATED BY ','
                                              ( first_name CHAR(7), last_name CHAR(8), year_of_birth CHAR(4)))
                            LOCATION ('info.dat'));

CREATE TABLE emp_load (first_name CHAR(15), last_name CHAR(20), year_of_birth CHAR(4))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_tab_dir
                            ACCESS PARAMETERS (RECORDS FIXED 20 FIELDS (first_name CHAR(7), last_name CHAR(8), year_of_birth CHAR(4)))
                            LOCATION ('info.dat'));

CREATE TABLE CUSTOMER_TABLE (cust_num VARCHAR2(10), order_num VARCHAR2(20), order_date DATE, item_cnt NUMBER, description VARCHAR2(100), order_total NUMBER(8,2))
    ORGANIZATION EXTERNAL ( TYPE ORACLE_HIVE
                            ACCESS PARAMETERS (
                                com.oracle.bigdata.tableName:  order_db.order_summary
                                com.oracle.bigdata.colMap:     {"col":"ITEM_CNT", "field":"order_line_item_count"}
                                com.oracle.bigdata.overflow:   {"action":"ERROR", "col":"DESCRIPTION"}
                                com.oracle.bigdata.errorOpt:   [{"action":"replace", "value":"INV_NUM" , "col":["CUST_NUM","ORDER_NUM"]} , {"action":"reject", "col":"ORDER_TOTAL"}]
                          ));
CREATE TABLE TT_BSTOFF_VERDICHT ( TrxKey NUMBER(12), BStoffPKey NUMBER(12), BStoffBOId VARCHAR2(40), BStoffBelegNr NUMBER(12), BStoffBetrag NUMBER(15,2), BStoffBetragWA NUMBER(15,2),  PRIMARY KEY (TrxKey, BStoffPKey)) ORGANIZATION INDEX;
CREATE TABLE WBXCRLOG (CRID NUMBER not null, CONFLCITTIME DATE default SYSDATE, CONSTRAINT PK_WBXCRLOG PRIMARY KEY(CONFLICTTIME,CRID) USING INDEX TABLESPACE SPLEX_INDX LOCAL) PARTITION BY RANGE(CONFLICTTIME) INTERVAL(NUMTOYMINTERVAL(1, 'MONTH')) STORE IN (SPLEX_DATA) ( PARTITION P201805 VALUES LESS THAN (TO_DATE('2018-06-01', 'YYYY-MM-DD')) TABLESPACE SPLEX_DATA, PARTITION P201806 VALUES LESS THAN (TO_DATE('2018-07-01', 'YYYY-MM-DD')) TABLESPACE SPLEX_DATA );
CREATE TABLE "MYUSER"."ITEMS" ("ID" NUMBER(4,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE, "NAME" VARCHAR2(255) NOT NULL ENABLE, "DESCRIPTION" VARCHAR2(512), "COST" FLOAT(126), PRIMARY KEY ("ID") USING INDEX ENABLE, SUPPLEMENTAL LOG DATA (ALL) COLUMNS);
CREATE TABLE TEST001(ID NUMBER, NAME VARCHAR2(1) DEFAULT ('0'));
create table InversePickingAssignmentGroup ( name nvarchar2(20), areaId nvarchar2(10), whLocId nvarchar2(20), enabled number(1) default 0) tablespace WAMASDATA;
create table "DVSADM".CMP3$58238005  nocompress tablespace "DVS_PROOF" nologging lob (VALUE) store as (tablespace "DVS_PROOF" enable storage in row nocache nologging) as select /*+ DYNAMIC_SAMPLING(0) FULL("DVSADM"."DVS_ARCHIVE") */ *  from "DVSADM"."DVS_ARCHIVE"  sample block( 6.734) mytab;
CREATE TABLE "APPLSYS"."FND_SEC_GUIDELINES_TL"
   (    "CODE" VARCHAR2(20) NOT NULL ENABLE,
    "TITLE" VARCHAR2(100) NOT NULL ENABLE,
    "DESCRIPTION" VARCHAR2(2000) NOT NULL ENABLE,
    "INFO" CLOB NOT NULL ENABLE,
    "LANGUAGE" VARCHAR2(30) NOT NULL ENABLE,
    "SOURCE_LANG" VARCHAR2(4) NOT NULL ENABLE,
    "CREATED_BY" VARCHAR2(30) NOT NULL ENABLE,
    "CREATION_DATE" DATE NOT NULL ENABLE,
    "LAST_UPDATED_BY" NUMBER(15,0) NOT NULL ENABLE,
    "LAST_UPDATE_DATE" DATE NOT NULL ENABLE,
    "LAST_UPDATE_LOGIN" NUMBER(15,0)
   ) PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
  STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
  TABLESPACE "APPS_TS_TX_DATA"
 LOB ("INFO") STORE AS (
  TABLESPACE "APPS_TS_TX_DATA" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
  NOCACHE
  STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT))
;
CREATE TABLE "t_ddl_0027"(
    "PID" INT,
    "FID" INT,
    "NAME" VARCHAR(50) DEFAULT 'Tom',
    "ADDRESS" VARCHAR(50) NOT NULL,
    "DEPT" VARCHAR(50),
    CONSTRAINT "PK_ID" PRIMARY KEY("PID"),
    CONSTRAINT "CK_DEPT" CHECK ("DEPT" IN('IT', 'SALES', 'MANAGER')));
CREATE TABLE "ET$xxxx"
   (    "MANDT",
    "WERKS",
    "MATNR",
    "GZEQUNR",
    "GZEQUNED",
    "MODNE",
    "NAME1",
    "MAKTX"
   ) ORGANIZATION EXTERNAL
    ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "DMPDP" ACCESS PARAMETERS ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE "xxxx"."xxxx"  JOB ( "GGS","SYS_EXPORT_TABLE_01",1) WORKERID 1 PARALLEL 1 VERSION '11.2.0.0.0' ENCRYPTPASSWORDISNULL  COMPRESSION ENABLED  ENCRYPTION DISABLED  DBLINK 'TOPRD') LOCATION ('xxxx.dat') )  PARALLEL 1 REJECT LIMIT UNLIMITED
    AS SELECT /*+ PARALLEL(KU$,1) */ "MANDT", "WERKS", "MATNR", "GZEQUNR", "GZEQUNED", "MODNE", "NAME1", "MAKTX"
    FROM RELATIONAL("xxxx"."xxxx" @TOPRD NOT XMLTYPE) AS OF SCN 216399751091 KU$;
CREATE TABLE "C##RCUSER"."JSON_TRANS" ( "ID" NUMBER(8,0) NOT NULL ENABLE, "TRANS_MSG" CLOB, CONSTRAINT "CHECK_JSON" CHECK (trans_msg is json) ENABLE, PRIMARY KEY ("ID") USING INDEX ENABLE, SUPPLEMENTAL LOG DATA (ALL) COLUMNS);

CREATE TABLE "ASEDBUSR"."ECLAIMPROCESS"
(	"PKEY" NUMBER(12,0) NOT NULL ENABLE,
	"BOID" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"METABO" NUMBER(12,0) NOT NULL ENABLE,
	"LASTUPDATE" TIMESTAMP (9) NOT NULL ENABLE,
	"PROCESSID" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ROWCOMMENT" VARCHAR2(15 CHAR),
	"CREATED" TIMESTAMP (9) NOT NULL ENABLE,
	"CREATEDUSER" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"REPLACED" TIMESTAMP (9) NOT NULL ENABLE,
	"REPLACEDUSER" VARCHAR2(40 CHAR),
	"ITSPROCSUMPKOGU" VARCHAR2(40 CHAR),
	"ITSPROCSUMINVOICE" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"IMPORTDATE" DATE NOT NULL ENABLE,
	"BATCHIMPORTSTATUS" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ITSECLAIMPROCVERS" VARCHAR2(40 CHAR),
	"ITSECLAIMPROCPAT" VARCHAR2(40 CHAR),
	"ITSPROCVERANLASSLE" VARCHAR2(40 CHAR),
	"ITSPROCAUSFUEHRLE" VARCHAR2(40 CHAR),
	"ITSPROCRECHSTELLER" VARCHAR2(40 CHAR),
	"ITSPROCBEARBOE" VARCHAR2(40 CHAR),
	"ITSPROCBEARBUSER" VARCHAR2(40 CHAR),
	"ITSSUMPROCZAHLER" VARCHAR2(40 CHAR),
	"ITSECLAIMSCHADEN" VARCHAR2(40 CHAR),
	"ITSECPLSTABRTYP" VARCHAR2(40 CHAR),
	"ITSECLAIMLSTFALL" VARCHAR2(40 CHAR),
	"ITSECLAIMFDOSSIER" VARCHAR2(40 CHAR),
	"VERARBEITUNGCOUNT" NUMBER(12,0),
	"ITSPROCBATCHLAUF" VARCHAR2(40 CHAR),
	"VORBEHALTOVR" NUMBER(12,0) NOT NULL ENABLE,
	"LSTSPERRENOVR" NUMBER(12,0) NOT NULL ENABLE,
	"SISTIERUNGOVR" NUMBER(12,0) NOT NULL ENABLE,
	"RUECKWEISUNGTEXT" VARCHAR2(350 CHAR),
	"FEHLERTEXT" VARCHAR2(1024 CHAR),
	"PROVSTATUS" VARCHAR2(40 CHAR),
	"ECLAIMSTATUS" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"SBENTSCHEID" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ITSSUMPROCLSTABR" VARCHAR2(40 CHAR),
	"RESPONSE" VARCHAR2(4000 CHAR),
	"MODIFIALLOWED" VARCHAR2(40 CHAR),
	"LSTAUFSCHUBOVR" NUMBER(12,0) NOT NULL ENABLE,
	"ISEXTERNALSTORED" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ITSPROCGBEREICH" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ITSPROCECLAIMMAND" VARCHAR2(40 CHAR),
	"HABEGRUENDUNG" VARCHAR2(40 CHAR),
	"ITSKUERZUNG" VARCHAR2(40 CHAR),
	"KUERZUNGPROZENT" NUMBER(9,2),
	"ITSSUMPROCKOGU" VARCHAR2(40 CHAR),
	"EKOGURUECKWCODE" VARCHAR2(40 CHAR),
	"EKOGUERLEDIGTCODE" VARCHAR2(40 CHAR),
	"SECONDOPINION" VARCHAR2(40 CHAR),
	"ITSTHERAPIEMETHODE" VARCHAR2(40 CHAR),
	"ITSPROCSUMKOGU" VARCHAR2(40 CHAR),
	"ITSLERBMELDUNG" VARCHAR2(40 CHAR),
	"PROCBEHANDORTOVR" NUMBER(12,0) NOT NULL ENABLE,
	"ITSAUSZAHLUNGSTYP" VARCHAR2(40 CHAR),
	"AUSZAHLTYPOVR" NUMBER(12,0) NOT NULL ENABLE,
	"VERARBEITSTATUS" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"FOREIGNCURRACTIV" NUMBER(12,0) NOT NULL ENABLE,
	"PROCRECHSTOVR" NUMBER(12,0) NOT NULL ENABLE,
	"ISESR" VARCHAR2(40 CHAR),
	"ITSKSKTARKOST" VARCHAR2(40 CHAR),
	"ITSPROCBEHANDORT" VARCHAR2(40 CHAR),
	"STATUS" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ERFREVISION" NUMBER(12,0) NOT NULL ENABLE,
	"ITSXMLSTORE" VARCHAR2(40 CHAR),
	"ITSANNULXMLSTORE" VARCHAR2(40 CHAR),
	"VORBESCHEXPFREIG" VARCHAR2(40 CHAR),
	"EINFEXPFREIG" VARCHAR2(40 CHAR),
	"SANKTIONSTUFEFLAG" VARCHAR2(40 CHAR),
	"SANKTIONSTUFEOVR" NUMBER(12,0) NOT NULL ENABLE,
	"BESTDATNOTENKURS" DATE,
	"RKOPFCOMMENT" VARCHAR2(255 CHAR),
	"INTERNCOMMENT" VARCHAR2(4000 CHAR),
	"OVRINTERNCOMMENT" NUMBER(12,0) NOT NULL ENABLE,
	"COMMENTLERB" VARCHAR2(4000 CHAR),
	"COMMENTLERBOVR" VARCHAR2(4000 CHAR),
	"COMMENTLERBKOPF" VARCHAR2(1000 CHAR),
	"COMMENTLERBKOPFPOS" VARCHAR2(40 CHAR),
	"OVRCOMMENTLERB" NUMBER(12,0) NOT NULL ENABLE,
	"OVRCOMMENTLERBKOPF" NUMBER(12,0) NOT NULL ENABLE,
	"COMMENTVERS" VARCHAR2(4000 CHAR),
	"COMMENTVERSOVR" VARCHAR2(4000 CHAR),
	"OVRCOMMENTVERS" NUMBER(12,0) NOT NULL ENABLE,
	"OVRCOMMENTVERSKOPF" NUMBER(12,0) NOT NULL ENABLE,
	"COMMENTVERSKOPF" VARCHAR2(1000 CHAR),
	"COMMENTVERSKOPFPOS" VARCHAR2(40 CHAR),
	"USEESRREDBANKINFO" VARCHAR2(40 CHAR),
	"ISKOGU" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ITSBEHANDLUNG" VARCHAR2(40 CHAR),
	"ITSSTORNOECLPROC" VARCHAR2(40 CHAR),
	"KOPIERT" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"STORNOCODE" VARCHAR2(40 CHAR),
	"MCDINVOICESTATUS" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ITSMCDXMLSTORE" VARCHAR2(40 CHAR),
	"TARIFGRPMDC" VARCHAR2(35 CHAR),
	"SUMPOTEINSPARUNG" NUMBER(14,4) NOT NULL ENABLE,
	"ABSCHLUSSDAT" TIMESTAMP (9),
	"PROCESSDATE" DATE,
	"LSTABRDATE" DATE,
	"LSTABRSTORNODATE" DATE,
	"REGELVARIABLE1" VARCHAR2(255 CHAR),
	"TREATMENTBEGIN" DATE,
	"TREATMENTEND" DATE,
	"ITSECLAIMPROCINS" VARCHAR2(40 CHAR),
	"ITSABTRGERKLG" VARCHAR2(40 CHAR),
	"ITSPROCCOPYFROM" VARCHAR2(40 CHAR),
	"ARCHIVETAG" VARCHAR2(40 CHAR),
	"ECLSABEDRGSTATUS" VARCHAR2(40 CHAR),
	"RECHNUNGSTYP" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"MCDVISIBLEDATE" TIMESTAMP (9),
	"ITSSENDUNG" VARCHAR2(40 CHAR),
	"MDBID" VARCHAR2(255 CHAR),
	"LSTZAHLUNGAN" VARCHAR2(40 CHAR),
	"LSTFORDERUNGAN" VARCHAR2(40 CHAR),
	"LSTZAHLUNGANOVR" NUMBER(12,0) NOT NULL ENABLE,
	"LSTFORDERUNGANOVR" NUMBER(12,0) NOT NULL ENABLE,
	"FRISTBEGINN" DATE DEFAULT NULL NOT NULL ENABLE,
	"EXTPRUEFSYSSTATUS" VARCHAR2(40 CHAR) DEFAULT NULL,
	"EXTPRUEFSYSDATE" DATE DEFAULT NULL,
	 SUPPLEMENTAL LOG DATA (ALL) COLUMNS
   ) PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255  LOGGING
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT"
  PARTITION BY LIST ("REPLACED")
 (PARTITION "P_CURR"  VALUES (TIMESTAMP '3000-01-01 00:00:00') SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT" ,
 PARTITION "P_ARCH"  VALUES (DEFAULT) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 40 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 8388608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "ASEDBUSR_DAT" )  ENABLE ROW MOVEMENT;
  CREATE UNIQUE INDEX "ASEDBUSR"."PK1019008" ON "ASEDBUSR"."ECLAIMPROCESS" ("PKEY")
  PCTFREE 10 INITRANS 80 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 "ASEDBUSR_DAT";
  ALTER TABLE "ASEDBUSR"."ECLAIMPROCESS" ADD CONSTRAINT "PK1019008" PRIMARY KEY ("PKEY")
  USING INDEX "ASEDBUSR"."PK1019008"  ENABLE;

CREATE TABLE "ASEDBUSR"."DOCBESTPARAMATTR"
(	"PKEY" NUMBER(12,0) NOT NULL ENABLE,
	"BOID" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"METABO" NUMBER(12,0) NOT NULL ENABLE,
	"LASTUPDATE" TIMESTAMP (9) NOT NULL ENABLE,
	"PROCESSID" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"ROWCOMMENT" VARCHAR2(15 CHAR),
	"CREATED" TIMESTAMP (9) NOT NULL ENABLE,
	"CREATEDUSER" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"REPLACED" TIMESTAMP (9) NOT NULL ENABLE,
	"REPLACEDUSER" VARCHAR2(40 CHAR),
	"ARCHIVETAG" VARCHAR2(40 CHAR),
	"GUELTAB" DATE NOT NULL ENABLE,
	"GUELTBIS" DATE NOT NULL ENABLE,
	"ITSPARAMATTRDEF" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"CODEVALUE" VARCHAR2(40 CHAR),
	"ITSBOVALUE" VARCHAR2(40 CHAR),
	"CLSBOVALUE" NUMBER(12,0),
	"INTVALUE" NUMBER(12,0),
	"DECVALUE" NUMBER(18,6),
	"TEXTVALUE" VARCHAR2(4000 CHAR),
	"DATEVALUE" DATE,
	"ITSDOCBESTELLUNG" VARCHAR2(40 CHAR) NOT NULL ENABLE,
	"MDBID" VARCHAR2(255 CHAR),
	"BIGTEXTVALUE" CLOB,
	"CK_CODEVALUE" VARCHAR2(40 CHAR),
	 CONSTRAINT "PK500332" PRIMARY KEY ("PKEY")
  USING INDEX PCTFREE 10 INITRANS 80 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 "ASEDBUSR_DAT"  ENABLE,
	 SUPPLEMENTAL LOG DATA (ALL) COLUMNS
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 40 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 "ASEDBUSR_DAT"
 LOB ("BIGTEXTVALUE") STORE AS SECUREFILE (
  TABLESPACE "ASEDBUSR_DAT" ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES
  STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;

CREATE TABLE "P1FOFF"."FOFF_MEMBER_SUBSCRIPTION"
(	"DATE_INSERTED" DATE NOT NULL ENABLE,
	"EMPL_NO_INSERTED" NUMBER(9,0) NOT NULL ENABLE,
	"DATE_CHANGED" DATE,
	"EMPL_NO_CHANGED" NUMBER(9,0),
	"NO" NUMBER(10,0) DEFAULT ON NULL "P1FOFF"."FOFF_MESU_SEQ1"."NEXTVAL" NOT NULL ENABLE,
	"MEMB_NO" NUMBER(10,0) NOT NULL ENABLE,
	"SUBD_NO" NUMBER(10,0) NOT NULL ENABLE,
	"STCO_CODE" VARCHAR2(3 CHAR) NOT NULL ENABLE,
	"STCO_STTY_CODE" VARCHAR2(1 CHAR) NOT NULL ENABLE,
	"MESU_NO" NUMBER(10,0),
	"ORDE_NO" NUMBER(10,0),
	"DATE_PURCHASE" DATE NOT NULL ENABLE,
	"PURCHASE_PRICE" NUMBER(5,2) NOT NULL ENABLE,
	"DATE_END_REFLECTION_PERIOD" DATE,
	"DATE_START" DATE NOT NULL ENABLE,
	"DATE_END" DATE NOT NULL ENABLE,
	"DATE_CANCELLED" DATE,
	"GROUP_NO" NUMBER(10,0) NOT NULL ENABLE,
	"SEME_NO" NUMBER(10,0),
	"REVENUE_PER_DAY" NUMBER(7,5) NOT NULL ENABLE,
	"TYPE" VARCHAR2(1 CHAR) NOT NULL ENABLE,
	"MNDT_NO" NUMBER(10,0),
	"DATE_END_INITIAL" DATE NOT NULL ENABLE,
	"PAYT_CODE" VARCHAR2(2 CHAR),
	"REGULAR_PRICE" NUMBER(5,2) NOT NULL ENABLE,
	"INCE_CODE" VARCHAR2(10 CHAR),
	"REFUND_AMOUNT" NUMBER(5,2),
	"REFUND_DESCRIPTION" VARCHAR2(4000 CHAR),
	"PAY_TRANSACTION_SUCCESS_FLG" VARCHAR2(1 CHAR) DEFAULT 'N' NOT NULL ENABLE,
	"MSCA_NO" NUMBER(10,0),
	"AMOUNT_CREDIT" NUMBER(5,2),
	"FIRST_ORDE_NO" NUMBER(10,0),
	"PROMOTIONAL_CODE" VARCHAR2(20 CHAR),
	 CONSTRAINT "FOFF_MESU_PK" PRIMARY KEY ("NO") USING INDEX  ENABLE,
	 CONSTRAINT "FOFF_MESU_CK2" CHECK ( coalesce( date_end_reflection_period, date_purchase ) >= date_purchase ) ENABLE,
	 CONSTRAINT "FOFF_MESU_CK1" CHECK ( date_end >= date_start ) ENABLE,
	 CONSTRAINT "FOFF_MESU_CK3" CHECK ( pay_transaction_success_flg in ( 'Y', 'N' ) ) ENABLE, SUPPLEMENTAL LOG DATA (ALL) COLUMNS,
	 CONSTRAINT "FOFF_MESU_SUBD_FK1" FOREIGN KEY ("SUBD_NO") REFERENCES "P1FOFF"."FOFF_SUBSCRIPTION_DEF" ("NO") ENABLE,
	 CONSTRAINT "FOFF_MESU_STCO_FK1" FOREIGN KEY ("STCO_CODE", "STCO_STTY_CODE") REFERENCES "P1FOFF"."FOFF_STATUS_CODE" ("CODE", "STTY_CODE") ENABLE,
	 CONSTRAINT "FOFF_MESU_MESU_FK1" FOREIGN KEY ("MESU_NO") REFERENCES "P1FOFF"."FOFF_MEMBER_SUBSCRIPTION" ("NO") ENABLE,
	 CONSTRAINT "FOFF_MESU_ORDE_FK1" FOREIGN KEY ("ORDE_NO") REFERENCES "P1FOFF"."FOFF_ORDER" ("NO") ENABLE,
	 CONSTRAINT "FOFF_MESU_SEME_FK1" FOREIGN KEY ("SEME_NO") REFERENCES "P1FOFF"."FOFF_SERVICE_MEMO" ("NO") ENABLE,
	 CONSTRAINT "FOFF_MESU_MNDT_FK1" FOREIGN KEY ("MNDT_NO") REFERENCES "P1FOFF"."FOFF_MANDATE" ("NO") ENABLE,
	 CONSTRAINT "FOFF_MESU_MEMB_FK1" FOREIGN KEY ("MEMB_NO") REFERENCES "P1FOFF"."FOFF_MEMBER" ("NO") ENABLE,
	 CONSTRAINT "FOFF_MESU_INCE_FK1" FOREIGN KEY ("INCE_CODE") REFERENCES "P1FOFF"."FOFF_INCENTIVE" ("CODE") ENABLE,
	 CONSTRAINT "FOFF_MESU_MSCA_FK1" FOREIGN KEY ("MSCA_NO") REFERENCES "P1FOFF"."FOFF_MESU_CHANGE_ACTION" ("NO") DISABLE,
	 CONSTRAINT "FOFF_MESU_ORDE_FK2" FOREIGN KEY ("FIRST_ORDE_NO") REFERENCES "P1FOFF"."FOFF_ORDER" ("NO") ENABLE
);
CREATE TABLE "PRODUCT"."TOKENSTORE" (
	"AUTH_KEY" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
	"USER_NAME" VARCHAR2(32) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
	"APP_NAME" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
	"INSTANCE_NAME" VARCHAR2(255) COLLATE "USING_NLS_COMP",
	"LAST_ACTIVITY_TIME" NUMBER(*,0) NOT NULL ENABLE,
	"CONNECTED" NUMBER(*,0) NOT NULL ENABLE,
	"CLIENT_ID" NUMBER(*,0) NOT NULL ENABLE,
	"HOST" VARCHAR2(255) COLLATE "USING_NLS_COMP" DEFAULT ' ' NOT NULL ENABLE,
	 CONSTRAINT "PK_TOKENSTORE2" PRIMARY KEY ("AUTH_KEY")
     USING INDEX  ENABLE)
     DEFAULT COLLATION "USING_NLS_COMP";
CREATE TABLE "P_BL050044".CMP4$231516 organization heap tablespace "PT_LOB" lob (FILE_XML, FILE_IMG_F, FILE_IMG_R) store as (tablespace "PT_LOB" enable storage in row nocache nologging) compress for all operations nologging as select /*+ DYNAMIC_SAMPLING(0) */ * FROM "P_BL050044".CMP3$231516 mytab;

CREATE TABLE "BOSIT"."SETRAN"
   (    "TXNUM" VARCHAR2(100),
        "TXDATE" DATE,
        "ACCTNO" VARCHAR2(20),
        "TXCD" VARCHAR2(4),
        "NAMT" NUMBER DEFAULT 0,
        "CAMT" VARCHAR2(50),
        "REF" VARCHAR2(50),
        "DELTD" VARCHAR2(1),
        "AUTOID" NUMBER(20,0) DEFAULT 0,
        "ACCTREF" VARCHAR2(20),
        "TLTXCD" VARCHAR2(4),
        "BKDATE" DATE,
        "TRDESC" VARCHAR2(1000)
   )  DISABLE LOGICAL REPLICATION ;

CREATE TABLE "ZZZ"."TASKVOLUME"
   (    "TASK" NUMBER,
        "SUBJECT" NUMBER NOT NULL ENABLE,
        "VOL" NUMBER,
        "START_TIME" DATE,
        "END_TIME" DATE,
         SUPPLEMENTAL LOG DATA (ALL) COLUMNS,
         SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
         SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,
         SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS
   )
  PARTITION BY RANGE ("TASK")
  SUBPARTITION BY LIST ("VOL")
 (PARTITION "VOL_0"  VALUES LESS THAN (1)
 ( SUBPARTITION "VOL_0_R"  VALUES (-1) ,
  SUBPARTITION "VOL_0_01"  VALUES (01) ,
  SUBPARTITION "VOL_0_02"  VALUES (02) ,
  SUBPARTITION "VOL_0_03"  VALUES (03) ,
  SUBPARTITION "VOL_0_04"  VALUES (04) ) ,
 PARTITION "VOL_1"  VALUES LESS THAN (2)
 ( SUBPARTITION "VOL_1_R"  VALUES (-1) ,
  SUBPARTITION "VOL_1_01"  VALUES (01) ,
  SUBPARTITION "VOL_1_02"  VALUES (02) ,
  SUBPARTITION "VOL_1_03"  VALUES (03) ,
  SUBPARTITION "VOL_1_04"  VALUES (04) ) ,
 PARTITION "VOL_2"  VALUES LESS THAN (3)
 ( SUBPARTITION "VOL_2_R"  VALUES (-1) ,
  SUBPARTITION "VOL_2_01"  VALUES (01) ,
  SUBPARTITION "VOL_2_02"  VALUES (02) ,
  SUBPARTITION "VOL_2_03"  VALUES (03) ,
  SUBPARTITION "VOL_2_04"  VALUES (04) ) ,
 PARTITION "VOL_3"  VALUES LESS THAN (4)
 ( SUBPARTITION "VOL_3_R"  VALUES (-1) ,
  SUBPARTITION "VOL_3_01"  VALUES (01) ,
  SUBPARTITION "VOL_3_02"  VALUES (02) ,
  SUBPARTITION "VOL_3_03"  VALUES (03) ,
  SUBPARTITION "VOL_3_04"  VALUES (04) ));

CREATE TABLE "ESPP"."T_BUSINESS_OPERATION" (
    "BO_ID" NUMBER(38,0) NOT NULL ENABLE,
	"BO_DT" TIMESTAMP (3) NOT NULL ENABLE,
	"BO_TR_ID" NUMBER(38,0) NOT NULL ENABLE,
	"BO_DATA_ID" NUMBER(38,0),
	"BO_TYPE" NUMBER(6,0) NOT NULL ENABLE,
	"BO_ORIENTATION" NUMBER(1,0) NOT NULL ENABLE,
	"BO_CREATE_DT" TIMESTAMP (3) NOT NULL ENABLE,
	"BO_CREATE_TZ" NUMBER(4,0),
	"BO_DOG_ID" NUMBER(38,0) NOT NULL ENABLE,
	"BO_PAY_STATUS" NUMBER(6,0),
	"BO_REQ_STATUS" NUMBER(6,0),
	"BO_END_DT" TIMESTAMP (3),
	"BO_CDM_ID" NUMBER(38,0),
	 SUPPLEMENTAL LOG DATA (ALL) COLUMNS,
	 SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
	 SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,
	 SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,
	 CONSTRAINT "T_BO_TYPE_FK" FOREIGN KEY ("BO_TYPE")
	  REFERENCES "ESPP"."TD_OPERATION_TYPE" ("OT_ID") ENABLE,
	 CONSTRAINT "T_BO_PS_FK" FOREIGN KEY ("BO_PAY_STATUS")
	  REFERENCES "ESPP"."TD_STATUS" ("ST_ID") ENABLE,
	 CONSTRAINT "T_BO_RS_FK" FOREIGN KEY ("BO_REQ_STATUS")
	  REFERENCES "ESPP"."TD_STATUS" ("ST_ID") ENABLE,
	 CONSTRAINT "T_BO_TR_FK" FOREIGN KEY ("BO_TR_ID")
	  REFERENCES "ESPP"."T_TRANSACTION" ("TR_ID") ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  STORAGE (
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_ESPP"
  PARTITION BY REFERENCE ("T_BO_TR_FK")
  (PARTITION "SYS_P1329" SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  NOCOMPRESS LOGGING
  STORAGE (
  INITIAL 134217728 NEXT 134217728 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "TS_ESPP",
  PARTITION "SYS_P1330" SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  NOCOMPRESS LOGGING);
-- Create index
create index hr.name on hr.table (id,data) tablespace ts;
create unique index idx_eshp_auction_file_history_id on eshp_auction_file_history(history_id);
CREATE UNIQUE INDEX "IDENTITYDB"."IDX_CHANGENUMBERS_PK" ON "IDENTITYDB"."CHANGE_NUMBERS" ("CHANGE_NO", "EXPIRY_TIME") LOCAL (PARTITION "SYS_P44414" NOCOMPRESS ( SUBPARTITION "SYS_SUBP44398" , SUBPARTITION "SYS_SUBP44399" , SUBPARTITION "SYS_SUBP44400" , SUBPARTITION "SYS_SUBP44401" , SUBPARTITION "SYS_SUBP44403" , SUBPARTITION "SYS_SUBP44404" , SUBPARTITION "SYS_SUBP44405" , SUBPARTITION "SYS_SUBP44406" , SUBPARTITION "SYS_SUBP44407" , SUBPARTITION "SYS_SUBP44408" , SUBPARTITION "SYS_SUBP44409" , SUBPARTITION "SYS_SUBP44410" , SUBPARTITION "SYS_SUBP44411" , SUBPARTITION "SYS_SUBP44412" , SUBPARTITION "SYS_SUBP44413" ) );
CREATE UNIQUE INDEX "ORACDC"."DEPARTMENT_PK" ON "ORACDC"."DEPARTMENT" ("REQUEST_ID", "EMP_NO");
create TABLE BKP_cc AS (
select * FROM ca.EBS_BALANCETE_CC f);
       --     WHERE
       -- TO_CHAR(to_date('20'||f.nr_ano,'YYYY'),'YYYY')||'/'||TRIM(TO_CHAR(f.nr_mes,'00')) = :refCompAcad);
CREATE INDEX "SETTLEMENT"."TRADE_REQ_BASE_IDX6" ON "SETTLEMENT"."TRADE_REQ_BASE" ("UPDATED_AT") PCTFREE 10 INITRANS 2 MAXTRANS 255  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 "SETTLEMENT" PARALLEL 1;
-- Comment statement
COMMENT ON MATERIALIZED VIEW "MONITOR"."SQL_ALERT_LOG_ERRORS" IS 'snapshot table for snapshot MONITOR.SQL_ALERT_LOG_ERRORS';

CREATE TABLE tab (ID number(9) primary key, data xmltype, data2 xmltype) MEMOPTIMIZE FOR READ;
CREATE TABLE tab (ID number(9) primary key, data xmltype, data2 xmltype) NO MEMOPTIMIZE FOR READ;
CREATE TABLE tab (ID number(9) primary key, data xmltype, data2 xmltype) MEMOPTIMIZE FOR WRITE;
CREATE TABLE tab (ID number(9) primary key, data xmltype, data2 xmltype) NO MEMOPTIMIZE FOR WRITE;

CREATE GLOBAL TEMPORARY TABLE t_temp_log(id int, status varchar(10));
CREATE PRIVATE TEMPORARY TABLE t_temp_log(id int, status varchar(10));
CREATE SHARDED TABLE t_temp_log(id int, status varchar(10));
CREATE DUPLICATED TABLE t_temp_log(id int, status varchar(10));
CREATE IMMUTABLE TABLE t_temp_log(id int, status varchar(10));
CREATE BLOCKCHAIN TABLE t_temp_log(id int, status varchar(10));
CREATE IMMUTABLE BLOCKCHAIN TABLE t_temp_log(id int, status varchar(10));

-- Create table (Oracle 23+)
create table debezium.products if not exists (id NUMBER(4) GENERATED BY DEFAULT ON NULL AS IDENTITY (START WITH 101) NOT NULL PRIMARY KEY, name VARCHAR2(255) NOT NULL, description VARCHAR2(512), weight FLOAT);
create table debezium.fruits (
    id number annotations (SurrogateKey, UI_Display 'Fruit ID', Classification 'Fruit Info'),
    name varchar2(50) annotations (UI_Display 'Fruit Name', Classification 'Fruit Info'),
    description varchar2(50) annotations (UI_Display 'Description', Classification 'Fruit Info')
);
create table debezium.fruits (
    id number annotations (SurrogateKey, UI_Display 'Fruit ID', Classification 'Fruit Info'),
    name varchar2(50) annotations (UI_Display 'Fruit Name', Classification 'Fruit Info'),
    description varchar2(50) annotations (UI_Display 'Description', Classification 'Fruit Info')
)
annotations (UI_Display 'Fruit Table', Classification 'Fruit Info');
CREATE TABLE SCHEMA_B.TABLE_A (
    C_DATE VARCHAR2(8) NOT NULL,
    C_SN NUMBER NOT NULL

)
PARTITION BY RANGE ( C_DATE )
--INTERVAL ( numtoyminterval( 1, 'MONTH' ) )
(
    PARTITION TABLE_A_202401 VALUES LESS THAN ('20240201'),
    PARTITION TABLE_A_202402 VALUES LESS THAN ('20240301'),
    PARTITION TABLE_A_202403 VALUES LESS THAN ('20240401'),
    PARTITION TABLE_A_202404 VALUES LESS THAN ('20240501'),
    PARTITION TABLE_A_202405 VALUES LESS THAN ('20240601'),
    PARTITION TABLE_A_202406 VALUES LESS THAN ('20240701'),
    PARTITION TABLE_A_202407 VALUES LESS THAN ('20240801'),
    PARTITION TABLE_A_202408 VALUES LESS THAN ('20240901'),
    PARTITION TABLE_A_202409 VALUES LESS THAN ('20241001'),
    PARTITION TABLE_A_202410 VALUES LESS THAN ('20241101'),
    PARTITION TABLE_A_202411 VALUES LESS THAN ('20241201'),
    PARTITION TABLE_A_202412 VALUES LESS THAN ('20250101'),
    PARTITION TABLE_A_202501 VALUES LESS THAN ('20250201')
) TABLESPACE TS_A;
CREATE TABLE "interval_type_test" (
    "id" number GENERATED BY DEFAULT AS IDENTITY (START WITH 1 INCREMENT BY 1) PRIMARY KEY,
    "i1" INTERVAL YEAR(9) TO MONTH DEFAULT (INTERVAL '10-3' YEAR TO MONTH) NULL,
    "i2" INTERVAL DAY(6) TO SECOND (9) DEFAULT (INTERVAL '1 2:34:56.789' DAY TO SECOND) NOT NULL
);
CREATE TABLE T1 (
 "NAME" VARCHAR(10) NOT NULL,
 "ID" INT NOT NULL,
 "ADDRESS" VARCHAR(255),
 "SQ_NUMBER" NUMBER(10),
 "PQ_NUMBER" NUMBER(10),
 CONSTRAINTS UQ1 UNIQUE ("SQ_NUMBER", "PQ_NUMBER"));
CREATE TABLE DWH_INT_DBT.sensors_raw (
  SOURCE                 VARCHAR2(50),
  EVENTTS                VARCHAR2(30))
  STORAGE (
    BUFFER_POOL      DEFAULT
    FLASH_CACHE      DEFAULT
    CELL_FLASH_CACHE DEFAULT)
  NOCOMPRESS
  NOCACHE
  RESULT_CACHE (MODE DEFAULT)
  NOPARALLEL
  NOMONITORING;
-- Create index (Oracle 23+)
create index hr.name IF NOT EXISTS on hr.table (id,data) tablespace ts;
-- Create user (Oracle 23+)
CREATE USER debezium IF NOT EXISTS IDENTIFIED BY abc;
-- Create tablespace (Oracle 23+)
CREATE TABLESPACE LOGMINER_TBS IF NOT EXISTS DATAFILE '/opt/oracle/oradata/ORCLCDB/logminer_tbs.dbf' SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
-- Create view (Oracle 23+)
CREATE VIEW THE_VIEW IF NOT EXISTS AS SELECT ID, NAME FROM THE_TABLE WHERE ID > 10;

-- Create Audit Policy
CREATE AUDIT POLICY TABLE_POL PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE;
CREATE AUDIT POLICY DML_POL ACTIONS DELETE ON HR.EMPLOYEES, INSERT ON HR.EMPLOYEES, UPDATE ON HR.EMPLOYEES, ALL ON HR.DEPARTMENTS;
CREATE AUDIT POLICY SECURITY_POL ACTIONS ADMINISTER KEY MANAGEMENT;
CREATE AUDIT POLICY DIR_POL ACTIONS READ DIRECTORY, WRITE DIRECTORY, EXECUTE DIRECTORY;
CREATE AUDIT POLICY ALL_ACTIONS_POL ACTIONS ALL;
CREATE AUDIT POLICY DP_ACTIONS_POL ACTIONS COMPONENT = DATAPUMP IMPORT;
CREATE AUDIT POLICY JAVA_POL ROLES JAVA_ADMIN, JAVA_DEPLOY;
CREATE AUDIT POLICY HR_ADMIN_POL PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ACTIONS DELETE ON HR.EMPLOYEES, INSERT ON HR.EMPLOYEES, UPDATE ON HR.EMPLOYEES, ALL ON HR.DEPARTMENTS, LOCK TABLE ROLES AUDIT_ADMIN, AUDIT_VIEWER;
CREATE AUDIT POLICY ORDER_UPDATES_POL ACTIONS UPDATE ON OE.ORDERS WHEN 'SYS_CONTEXT(''USERENV'', ''IDENTIFICATION_TYPE'') = ''EXTERNAL''' EVALUATE PER SESSION;
CREATE AUDIT POLICY EMP_UPDATES_POL ACTIONS DELETE ON HR.EMPLOYEES, INSERT ON HR.EMPLOYEES, UPDATE ON HR.EMPLOYEES WHEN 'UID NOT IN (100, 105, 107)' EVALUATE PER STATEMENT;
CREATE AUDIT POLICY LOCAL_TABLE_POL PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE CONTAINER = CURRENT;
CREATE AUDIT POLICY COMMON_ROLE1_POL ROLES C CONTAINER = ALL;

CREATE OR REPLACE NONEDITIONABLE PACKAGE BODY tidy_html_snippet_pkg AS FUNCTION tidy(i_html_snippet IN CLOB) RETURN CLOB; FUNCTION tidy(i_html_snippet IN VARCHAR2) RETURN CLOB; END tidy_html_snippet_pkg;
