Home » RDBMS Server » Server Utilities » Error in DB verify ORA-34465
Error in DB verify ORA-34465 [message #377327] Mon, 22 December 2008 06:59 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Hi,

Mostly i have used dbv.exe for checking the block corruption. When i came to know that DBMS_DBVERIFY also can be used, i have used the below simple procedure to check for the file corruption.

DECLARE
vOutput VARCHAR2(4000) := '';
vError VARCHAR2(4000) := '';
vStats VARCHAR2(4000) := '';
BEGIN
dbms_dbverify.dbv2('c:\oracle\product\10.2.0\oradata\test\test01.dbf',
1,2, 8192, vOutput, vError, vStats);
dbms_output.put_line('Output: ' || vOutput);
dbms_output.put_line('Error: ' || vError);
dbms_output.put_line('Stats: ' || vStats);
END;
/


I get the error as ORA-34465. Message 34465 not found.

Did anyone came across this error?

Thanks in advance,
Seenu.
Re: Error in DB verify ORA-34465 [message #377342 is a reply to message #377327] Mon, 22 December 2008 08:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session.

Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: Error in DB verify ORA-34465 [message #377352 is a reply to message #377327] Mon, 22 December 2008 08:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
By the way, are you sure dbms_verify is from Oracle?

http://www.oracle.com/pls/db102/print_hit_summary?search_string=dbms_dbverify
Summary of Documentation Search Results: dbms_dbverify
Your search term did not match any of these documentation libraries:

Oracle Database 8i, 9i Release 2, 10g Release 1, 10g Release 2, 11g Release 1, Express Edition
Oracle Application Server 9i Release 2, 10g Release 1, 10g Release 2
Oracle Collaboration Suite 9i Release 2, 10g Release 1

Regards
Michel

[Updated on: Mon, 22 December 2008 08:26]

Report message to a moderator

Re: Error in DB verify ORA-34465 [message #377356 is a reply to message #377327] Mon, 22 December 2008 08:39 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member
The version i am using is 10.2.0.4.0 on windows platform.

DBMS_DBVERIFY package comes under the sys schema.

herewith i have attached the screenshot of this.

Please take a look of this.

Thanks,
Seenu.
Re: Error in DB verify ORA-34465 [message #377372 is a reply to message #377356] Mon, 22 December 2008 10:09 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I can't see anything on your screenshot that proves the package is from Oracle.
As I pointed above, Oracle itself does not know it (unless in its documentation of any version). In addition, it is also unknown from Metalink. Where did you get it? I precise it is NOT in 10.2.0.4 delivery.

Regards
Michel
Previous Topic: Export in conventional path
Next Topic: Error
Goto Forum:
  


Current Time: Mon Dec 23 19:41:42 CST 2024