Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-01294: error occurred while processing information in
dictionary file string, possible corruption

Answers were Sorted based on User's Feedback



ORA-01294: error occurred while processing information in dictionary file string, possible corrupti..

Answer / johnpaul

After successfully creating the dictionary to a flat file,
when attempting to start the Logminer utility, it fails
with errors:

ERROR at line 1:
ORA-01294: error occurred while processing information in
dictionary file , possible corruption
ORA-06512: at "SYS.DBMS_LOGMNR", line 53
ORA-06512: at line 1


Cause
The ATTRIBUTE$_TABLE is not being created in the dictionary
file


If the dictionary file is opened, we can see the syntax to
insert into the ATTRIBUTE$_TABLE table:

INSERT_INTO ATTRIBUTE$_TABLE VALUES
(00000000000000000000000000000003,1,'KOTADKVN',1,00000000000
000000000000000000013,1,,2,,,,,,'',0,,,,,,,);

However, the syntax to create the table should be prior to
the insert statement and it is missing. It should contain
the following:

CREATE_TABLE ATTRIBUTE$_TABLE (TOID RAW(16), VERSION# NUMBER
(22), NAME VARCHAR2(30), ATTRIBUTE# NUMBER(22), ATTR_TOID
RAW(16), ATTR_VERSION# NUMBER(22), SYNOBJ# NUMBER(22),
PROPERTIES NUMBER(22), CHARSETID NUMBER(22), CHARSETFORM
NUMBER(22), LENGTH NUMBER(22), PRECISION# NUMBER(22), SCALE
NUMBER(22), EXTERNNAME VARCHAR2(4000), XFLAGS NUMBER(22),
SPARE1 NUMBER(22), SPARE2 NUMBER(22), SPARE3 NUMBER(22),
SPARE4 NUMBER(22), SPARE5 NUMBER(22), SETTER NUMBER(22),
GETTER NUMBER(22) );



Solution
1. Use the online catalog

Example:
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS =>
DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

Is This Answer Correct ?    0 Yes 0 No

ORA-01294: error occurred while processing information in dictionary file string, possible corrupti..

Answer / guest

Cause: The dictionary file is corrupt.

Action: Get a new dictionary file.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30488: argument should be a function of expressions in PARTITION BY

1 Answers  


ORA-02481: Too many processes specified for events (max string)

1 Answers  


ORA-00482: LMD* process terminated with error

1 Answers  


ORA-22898: existing scope clause on "string" points to a table other than the one mentioned in the referential constraint

1 Answers  


DRG-11621: URL store: socket open error for string

1 Answers  


TNS-00083: (USER or ADMIN) in the argument field

1 Answers  


ORA-16030: session specific change requires a LOG_ARCHIVE_DEST_n destination

1 Answers  


ORA-07685: sou2os: supervisor stack set error

1 Answers  


NNL-00047: LDAP modify returned error: 0xnumber, string

1 Answers  


ORA-28168: attempted to grant password-protected role

1 Answers  


NID-00102: Garbled target string

1 Answers  


NNL-00022: error changing trace level from string to string, level change ignored

1 Answers  


Categories