Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

-- Unable to render TABLE DDL for object with DBMS_METADATA attempting internal generator. ver 4.0.2

2725114Aug 3 2014 — edited Aug 4 2014

Hi

I'm facing problem during extraction of DDL of specific tables (objects ??) using version 4.0.2 (and 4.0.1 as well), did not checked on older versions.

Database ORACLE 11.2.03 on Linux.

SQL Developer on 64 bit Windows.

The table is own by user DR as well as other tables.

Trying to extract DDL as table owner I'receiving

-- Unable to render TABLE DDL for object DR.T_STAFF_ABSENCE with DBMS_METADATA attempting internal generator.

ALTER TABLE T_STAFF_ABSENCE

ADD CONSTRAINT T_STAFF_ABSENCE_STAFF_FK FOREIGN KEY

(

  STAFF_ID

)

REFERENCES T_STAFF

(

  STAFF_ID

)

ENABLECREATE TABLE T_STAFF_ABSENCE

(.......................

When I tried to do using differ user (with more privileges) I'm receiving correct DDL

  CREATE TABLE "DR"."T_STAFF_ABSENCE"

   ( "REQUEST_ID" NUMBER(9,0) NOT NULL ENABLE,

  "STAFF_ABSENCE_ID" NUMBER(9,0),

  "STAFF_EXTID" VARCHAR2(50 CHAR) NOT NULL ENABLE,

  "STAFF_ID" NUMBER(9,0) NOT NULL ENABLE,

  "ABSENCE_TYPE_CODE" VARCHAR2(80 CHAR) NOT NULL ENABLE,

  "ABSENCE_FROM" DATE NOT NULL ENABLE,

  "ABSENCE_END" DATE,

  "OPERATION_TYPE" VARCHAR2(3 CHAR),

  "OPERATION_USER_LOGIN" VARCHAR2(30 CHAR),

  "OPERATION_TIME" DATE,

  CONSTRAINT "T_STAFF_ABSENCE_PK" PRIMARY KEY ("STAFF_ABSENCE_ID")

  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

........................................

In schema DR I have as well other tables.

select * from all_tables where owner = 'DR' AND TABLE_NAME LIKE 'T_STAFF%'

DRT_STAFFTSDR_DEFAULTVALID10
DRT_STAFF_ABSENCETSDR_DEFAULTVALID10
DRT_STAFF_CASH_DEFFICTSDR_DEFAULTVALID10
DRT_STAFF_GROUPTSDR_DEFAULTVALID10
DRT_STAFF_INCOMETSDR_DEFAULTVALID10
DRT_STAFF_RELATIONTSDR_DEFAULTVALID10
DRT_STAFF_WEB_ACTIVITYTSDR_DEFAULTVALID10

With some of them I have no problem to extract their DDL, for some i face the same issue.

When using more powerful user I have no problem.

Any idea what can be source of issue ??

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2014
Added on Aug 3 2014
3 comments
8,278 views