Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_UTILITY

DBMS_UTILITY

From: ARUN K C <arun_k_c_at_hotmail.com>
Date: Thu, 29 Jun 2000 14:48:37 PDT
Message-Id: <10543.110843@fatcity.com>


Hi all,
Can somebody help me out as to how to run this dbms_utility.block_address_file on 7.3 or 8 database If anybody has run this can you tell me how to use this utility so that I can get the file address Can you please send me some examples
Actually I have got a block corruption it is not showing when I do a validate structure on it but when I do the export it say unable to export row error and points to a column
I am not able to know how to solve this issue Please let me know
thank

SVRMGR> execute dbms_utility.data_block_address_file (604140218);
dbms_utility.data_block_address_file(604140218); *

ORA-06550: line 2, column 2:
PLS-00221: 'DATA_BLOCK_ADDRESS_FILE' is not a procedure or is undefined
ORA-06550: line 2, column 2:

PL/SQL: Statement ignored

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Thu Jun 29 2000 - 16:48:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US