LONG (RAW) columns

[Former Member]

Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.7.0 - Production

System: Microsoft Windows Server 2003 Enterprise Edition

-

---

Hello everyone,

I need to find all the tables in my schema that have LONG (RAW) columns. Is there a query that can be written to provide this.

Thanks for your time

[Former Member · Accepted solution]

select table_name from dba_tab_columns where DATA_TYPE like 'LONG%';

[former_member204746]

William Fee provided an excellent answer...

but why do you need that info? Are you planning an online reorg? if using brspace to reorg, it will reorg all tables you want except LONG and LONG RAW. SAP note 646681... by the way, DO NOt convert LONG RAW to BLOB as this is not supported in kernel 6.40 and below and makes kernel 7.00 a bit slower.

[Former Member]

Eric,

Sorry for getting back to you so late. We are on kernel 6.40 and I am running Oracle 9.2. Yes you are correct that BRSPACE will reorg all tables except LONG and LONG RAW. As note 646681 explains you can reorganize these tables offline using Export/Import. The only problem is that I can't take down our production server for that long. I need to reorg all tables with LONG and LONG RAW columns. I am using Quest Space Manager with LiveReorg to this, this utility works great.

Regards