OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » CLOB size (11g R1 Linux 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CLOB size [message #566023]

Mon, 10 September 2012 09:55

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello,

I'm trying to get size of CLOB column but not getting any output. Please suggest.

SQL> desc TABLE_STEP_INST234
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NUM_PENDING_PREREQS                       NOT NULL NUMBER(10)
 OBJID                                     NOT NULL VARCHAR2(31)
 OUTFLOW_BITS                                       NUMBER(19)
 PARAMS                                             CLOB
 PARENT2PROC_INST                          NOT NULL VARCHAR2(31)
 ROOT2PROC_INST                            NOT NULL VARCHAR2(31)
 START_TIME                                         DATE
 STATUS                                    NOT NULL NUMBER(2)
 

SQL>
SQL> select sum(dbms_lob.getlength (PARAMS)) from TABLE_STEP_INST234;

SUM(DBMS_LOB.GETLENGTH(PARAMS))
-------------------------------


SQL>

Report message to a moderator

Re: CLOB size [message #566025 is a reply to message #566023]

Mon, 10 September 2012 10:14

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is there anything in 1) your table 2) your CLOB.

Regards
Michel

Report message to a moderator

Re: CLOB size [message #566029 is a reply to message #566025]

Mon, 10 September 2012 10:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It works for me.

08:20:22 SQL> DESC DBADMIN.CLOB_TEST
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 NO						    NUMBER
 NAME						    CLOB

08:21:46 SQL> select COUNT(*) from DBADMIN.CLOB_TEST WHERE NAME IS NOT NULL;

  COUNT(*)
----------
      1000

08:22:02 SQL> select sum(dbms_lob.getlength (NAME)) from DBADMIN.CLOB_TEST;

SUM(DBMS_LOB.GETLENGTH(NAME))
-----------------------------
			28000

08:22:13 SQL>

Report message to a moderator

Previous Topic:	ORA-01578: ORACLE data block corrupted (file # 2, %
Next Topic:	TNS errors in Listener Log File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:49:55 CST 2024