Travellers Trail
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment