Home » RDBMS Server » Server Administration » CLOB size (11g R1 Linux 64bit)
CLOB size [message #566023] Mon, 10 September 2012 09:55 Go to next message
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>
Re: CLOB size [message #566025 is a reply to message #566023] Mon, 10 September 2012 10:14 Go to previous messageGo to next message
Michel Cadot
Messages: 60010
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is there anything in 1) your table 2) your CLOB.

Regards
Michel
Re: CLOB size [message #566029 is a reply to message #566025] Mon, 10 September 2012 10:22 Go to previous message
BlackSwan
Messages: 23157
Registered: January 2009
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> 

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


Current Time: Sun Dec 21 06:58:08 CST 2014

Total time taken to generate the page: 0.09347 seconds