dbv problem

[Matsul]

Hi all,

is dbverify not designed to handle temp tablespaces ? As below it works on system but will not accept a temporary tablespace. thanks


C:\ora_920\oradata\IMSII>dbv file=SYSTEM0.DBF blocksize=8192

DBVERIFY: Release 9.2.0.1.0 - Production on Thu Apr 5 10:28:31 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


DBV-00100: Specified FILE (SYSTEM0.DBF) not accessible

C:\ora_920\oradata\IMSII>dbv file=TEMP01.DBF blocksize=8192

DBVERIFY: Release 9.2.0.1.0 - Production on Thu Apr 5 10:29:26 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBVERIFY: Skipping temporary file TEMP01.DBF

C:\ora_920\oradata\IMSII>

 

[SantaMufasa]

Matsul,

Do you have evidence that there is a corruption in a TEMPORARY tablespace? If so, Oracle recommends that you:

1) create a new TEMPORARY tablespace.
2) assign the new tablespace as TEMPORARY_TABLESPACE for any users assigned the corrupted tablespace as their TEMPORARY.
3) drop the corrupted TEMPORARY tablespace.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Matsul]

Hi Mufasa,

problem solved. It seems the temp file was not actually in use and could just be deleteed. Not sure how it came about but problem is solved.

thanks