| logminer error [message #75433] |
Sun, 21 December 2003 06:09  |
ashokmote
Messages: 56
Registered: December 2003
|
Member |
|
|
when i execute this package i am getting this error
SQL> execute sys.dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer');
BEGIN sys.dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer'); END;
*
ERROR at line 1:
ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 777
ORA-06512: at line 1
SQL> execute dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer');
BEGIN dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_LOGMNR_D.BUILD' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL> execute sys.dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer');
BEGIN sys.dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer'); END;
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 777
ORA-06512: at line 1
SQL> execute dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer',options=>dbms_l
ogmnr_d.store_in_flatt_file);
BEGIN dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer',options=>dbms_logmnr_d
.store_in_flatt_file); END;
*
ERROR at line 1:
ORA-06550: line 1, column 75:
PLS-00201: identifier 'DBMS_LOGMNR_D.STORE_IN_FLATT_FILE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL> execute dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer',options=>sys.db
ms_logmnr_d.store_in_flatt_file);
BEGIN dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer',options=>sys.dbms_logm
nr_d.store_in_flatt_file); END;
*
ERROR at line 1:
ORA-06550: line 1, column 93:
PLS-00302: component 'STORE_IN_FLATT_FILE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL> execute sys.dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer',options=>sy
s.dbms_logmnr_d.store_in_flatt_file);
BEGIN sys.dbms_logmnr_d.build('dictionary.ora','E:Oraclelogminer',options=>sys.dbms_
logmnr_d.store_in_flatt_file); END;
*
ERROR at line 1:
ORA-06550: line 1, column 97:
PLS-00302: component 'STORE_IN_FLATT_FILE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL>
|
|
|
|
| Re: logminer error [message #75438 is a reply to message #75433] |
Mon, 29 December 2003 22:14  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
> ORA-01453: SET TRANSACTION must be first statement of transaction
Do a COMMIT or ROLLBACK before executing the first statement.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
