| Very Very Urgent Help [message #63778] |
Fri, 05 November 2004 23:01  |
Gunasekaran D
Messages: 11
Registered: August 2004
|
Junior Member |
|
|
Hi All,
In our database we have hundreds of tables.
We are using a tool and when we run the tool it's
accessing some table, and oracle is returning
invalid column error. Actually we dont no which
table the tool is referencing.
My question is; is it possible to find the table
which the tool is referencing from oracle log. If so, then where will the log for these activities will be stored.
Regards,
Gunasekaran
|
|
|
|
| Re: Very Very Urgent Help [message #63779 is a reply to message #63778] |
Sat, 06 November 2004 00:30  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Trace the session of 'the tool' and look in the tracefile for the statement that raises the error.
The tracefile will be created in the directory user_dump_dest (parameter in init.ora, or in SQL*Plus : show parameter user_dump_dest)
hth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
