Table DDL can't handle quoted field names?

[Stew Stryker]

I'm running the latest patch (that I could find), 8.0.0.1492 on Oracle 10gR2 (RAC).

In the Object Browser, if I right-click, choose View, then Show SQL, the generated DDL doesn't put double-quotes around the field names as it should.

For example:

-- Create table
create global temporary table AEO.ADVZR_SMC_SEGMENTATION_TMP
(
SEGMENT_ID VARCHAR2(50),
Campaign VARCHAR2(30),
Promotion VARCHAR2(30),
DCF Mkt SEGMENT VARCHAR2(34),
SubSegment VARCHAR2(30),
Appeal Date VARCHAR2(30),
Appeal VARCHAR2(30),
Fiscal Year VARCHAR2(4),
Status VARCHAR2(1),
LY Gift $ NUMBER(14,2),
Prospects # NUMBER(10)
)
on commit preserve rows;


What's up with that? This clearly isn't usable like this.

It should read:

create global temporary table AEO.ADVZR_SMC_SEGMENTATION_TMP
(
SEGMENT_ID VARCHAR2(50),
"Campaign" VARCHAR2(30),
"Promotion" VARCHAR2(30),
"DCF Mkt SEGMENT" VARCHAR2(34),
"SubSegment" VARCHAR2(30),
"Appeal Date" VARCHAR2(30),
"Appeal" VARCHAR2(30),
"Fiscal Year" VARCHAR2(4),
"Status" VARCHAR2(1),
"LY Gift $" NUMBER(14,2),
"Prospects #" NUMBER(10)
)
on commit preserve rows;


Also, in the Object Browser, in the object browser if I right-click and choose DBMS Metadata->DLL, I get an error message like:

ORA-31603: object "mytablename" of type TABLE not found in schema "MYSCHEMA"

Good luck,

Stew

 

[Stew Stryker]

Hmm, I just discovered version 8.0.0.1495, installed it and it looks these bugs have been fixed in it.

Oops, CORRECTION. The bug with DBMS_Metadata->DLL has been fixed. View still doesn't show the double-quotes.

Thanks,

Stew

 

[Stew Stryker]

I just installed the 8.0.1 beta and it looks like both these bugs are back.

Good luck!