RE: 10gR2 for solaris (64bit), AIX and HP released

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 31 Aug 2005 11:29:14 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395BA6E@usahm236.amer.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] 

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 -- 


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 31 2005 - 10:32:15 CDT