Environment: Oracle 8.1.7.4 on RedHat AS2.1
I'm in the process of preparing to convert a 90M row table from
heap-organized to index organized. I think I've pretty well got a
formula for doing the actual table conversion. It's a very basic
table, four NUMBER columns, with a PK on the first two.
There are two possibilities:
1) You are hitting a well known bug which doesn't allow you to turn
on 10046 by using set_ev or alter session. The only way to actually do
it is to use oradebug.
2) Your trace files are with Saddam Hussein.
On 12/01/2003 05:04:25 PM, Thomas A. La Porte wrote:
>
Here's something that may or may not be happening. It's something I ran into when
working with traces. Have you mv'd or rm'd any of your trace files? The reason I ask,
is because while doing some tracing of a certain session on Solaris recently, I began
the tracing, turned it off, and then mv'd
Though I'm intrigued by (2), I'm humbled by the missing (3)
option which you did not consider. That is that *I* had one too
many 0's in my trace event: it's 10046, not 100046! Your post
pointed out my typo, many thanks.
Serves me right for cutting and pasting into different sessions,
so that
Another possiblity is that file has once generated a trace file and you accidently rm
that file.
As the file is still opened by this session, the session still write the trace
content to that "rm"ed tracefile, so you are unable to read that file.
You can use lsof -p $SPID to identify wh
See once again an advantage of windows. It won't let you rm an in use
file
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of zhu chao
> Sent: 02 December 2003 05:34
> To: Multiple recipients of list ORACLE-L
> Su
4
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Where are my trace files going?
>
>
> Another possiblity is that file has once generated a trace
> file and you accidently rm that file.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Niall L