Friday 24 August 2007

BLOB's

To find the table the lob belongs to:
select table_name from user_lobs where SEGMENT_NAME = 'SYS_LOB033344496$$';

or chr(10)
set sqlblanklines on


DBVERIFY
Perfom while db is up and file is offline / online.
dbv file='/u22/oracle/oradata/NIDB/NIDB_BLOB_DATA_07.dbf' blocksize=8192

No comments: