DELETE FROM OGGTEST.TEST_TB@DL_RACDB;

COMMIT;

DROP TABLE OGGTEST.TEST_TB CASCADE CONSTRAINTS;

CREATE TABLE OGGTEST.TEST_TB

(

   NUM   NUMBER,

   D_DATE VARCHAR2 (20 BYTE)

         DEFAULT TO_CHAR (SYSDATE, 'YYYY-MM-DD HH24:MI:SS'),

   CONSTRAINT TEST_TB_PK PRIMARY KEY (NUM) USING INDEX

);

INSERT INTO OGGTEST.TEST_TB

   SELECT * FROM OGGTEST.TEST_TB@DL_RACDB;

COMMIT;

SELECT COUNT (*) FROM OGGTEST.TEST_TB@DL_RACDB

UNION ALL

SELECT COUNT (*) FROM OGGTEST.TEST_TB