Home » Server Options » Replication » logminer error
logminer error [message #75433] Sun, 21 December 2003 06:09 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: logminer error [message #200967 is a reply to message #75433] Thu, 02 November 2006 01:40 Go to previous message
blazingrock4u
Messages: 30
Registered: March 2006
Location: India
Member

"'E:Oraclelogminer"

Shouldn't it be 'E:\Oraclelogminer'
Are you missing "\" after "E:"
or is it a TYPO
Previous Topic: Replication of Oracle to SQL server
Next Topic: Materialized View Refresh
Goto Forum:
  


Current Time: Thu Mar 28 05:03:02 CDT 2024