Using a test system it appears to work:
UT1 > l
1 select dbms_metadata.get_ddl('TABLE','MARKLOB','MPOWEL01')
2* from sys.dual
UT1 > /
DBMS_METADATA.GET_DDL('TABLE','MARKLOB','MPOWEL01')
------------------------------------------------------------------------
--------
CREATE TABLE "MPOWEL01"."MARKLOB"
( "FLD1" VARCHAR2(10),
"FLD2" DATE,
"FLD3" CLOB
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 128
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USR"
LOB ("FLD3") STORE AS (
TABLESPACE "USR" ENABLE STORAGE IN ROW CHUNK 4096 PCTVERSION 10
NOCACHE
STORAGE(INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 128
PCTINCREASE 0 FREELISTS 1 FREELI
There is no data in my test table.
UT1 > select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
HTH -- Mark D Powell --
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gogala, Mladen
Sent: Wednesday, August 31, 2005 10:29 AM
To: Powell, Mark D; Oracle Discussion List
Subject: RE: 10gR2 for solaris (64bit), AIX and HP released
Mark, can you do me a favor and try to extract a definition of a table
with at least one LOB column from 9.2.0.6 database using
DBMS_METADATA.GET_DDL?
It doesn't work on Solaris and it doesn't work on Linux. I wonder
whether the bug was local to those two platforms or global?
--
Mladen Gogala
Ext. 121
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Wednesday, August 31, 2005 9:07 AM
To: Oracle Discussion List
Subject: RE: 10gR2 for solaris (64bit), AIX and HP released
>> Special mention of my black list:
9.2.0.6 with RAC (first time I had to roleback a patchset!).<<
[rollback]
Interesting we have found 9.2.0.6 RAC on AIX to be much more stable than
9.2.0.4 or 9.2.0.5. So far (couple months) we have not ran into the
system hang and crash problems that we suffered from on the lower
versions. However, two one-off patches were required prior to going
production. The first fixed a slow long on and very slow first run of
any query problem. I cannot remember what problem the second patch
fixed but both patches were AIX specific with the second being required
only for RAC environments.
HTH -- Mark D Powell --