LONG RAW

From: Charlie Mengler <charliem_at_mwh.com>
Date: Wed, 10 Jan 2001 10:52:30 -0800
Message-Id: <10737.126302@fatcity.com>

I'm supporting a 3rd party s/w application on an Oracle V8.1.6 instance. One table is highly fragmented and contains a LONG RAW field.

Other than export/import what are some ways of doing a "reorg" of this table?

Along these lines does anyone have a PL/SQL function or similar code that will return the size of the a LONG RAW field?

Please keep in mind that since this is a purchased application, I have no control over the data types used within Oracle.

TIA!

-- 
Charlie Mengler               Maintenance Warehouse  
charliem_at_mwh.com              10641 Scripps Summit Ct   
858-831-2229                  San Diego, CA 92131    
While there are NO stupid questions, why am
I plagued with LOTS of inquisitive idiots.

Received on Wed Jan 10 2001 - 12:52:30 CST