Forum Stats

  • 3,741,182 Users
  • 2,248,384 Discussions
  • 7,861,664 Comments

Discussions

Import -> Data Dictionary leads to empty table

unficyp
unficyp Member Posts: 182 Blue Ribbon

Hi,

what could have gone wrong when i use Import -> Data Dictionary and some of the imported tables are created but without any columns ?

I have PK definitions - but without any column, i have indexes - no columns again.

Using DM  20.2.0.167, Build 167.1538

thanks

Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,337 Employee
    edited Jul 8, 2020 7:55AM

    what is database version?

    Can you provide a DDL for table with failed import of columns?

    Philip

  • unficyp
    unficyp Member Posts: 182 Blue Ribbon
    edited Jul 8, 2020 9:57AM

    DB is 12.2.0.1, DataModeler is 20.02 - it works in the last 19.x version

    DDL created from toad:

    CREATE TABLE WMS_STATUS(  ID          NUMBER                          NOT NULL,  CODE        VARCHAR2(32 BYTE)                NOT NULL,  NAME        VARCHAR2(240 BYTE)              NOT NULL,  DESCRIPTION  VARCHAR2(4000 BYTE))LOGGINGNOCOMPRESSNOCACHE;CREATE UNIQUE INDEX PK_WMS_STATUS ON WMS_STATUS(ID)LOGGING;CREATE UNIQUE INDEX UK_WMS_STATUS_CODE ON WMS_STATUS(CODE)LOGGING;ALTER TABLE WMS_STATUS ADD (  CONSTRAINT PK_WMS_STATUS  PRIMARY KEY  (ID)  USING INDEX PK_WMS_STATUS  ENABLE VALIDATE);ALTER TABLE WMS_STATUS ADD (  CONSTRAINT UK_WMS_STATUS_CODE  UNIQUE (CODE)  USING INDEX UK_WMS_STATUS_CODE  ENABLE VALIDATE);CREATE OR REPLACE TRIGGER CG$BIR_WMS_STATUS BEFOREINSERT ON WMS_STATUS FOR EACH ROWBEGIN <<COLUMN_SEQUENCES>>BEGIN IF :NEW.ID IS NULL THENSELECT wms_id_seq.NEXTVAL INTO :NEW.ID FROM DUAL;END IF;END COLUMN_SEQUENCES;--<<COLUMN_DEFAULTS>>BEGIN:NEW.CODE := UPPER(:NEW.CODE);END COLUMN_DEFAULTS;END;/
  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,337 Employee
    edited Jul 10, 2020 8:12AM

    Hi,

    thanks for the example. Unfortunately it works for me - my database is 12.2.0.1 - PDB

    Philip

Sign In or Register to comment.