Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TRUNCATE TABLE acquire rollback segment?
An easier option for this one is:
sqlplus userid/password
alter session set sql_trace true;
truncate table XXX
exit
Then examine the trace file in sequence.
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Practical Oracle 8i: Building Efficient Databases Publishers: Addison-Wesley Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html Paul Drake wrote in message <3AF20CE9.8ABD8EE1_at_home.com>...Received on Fri May 04 2001 - 01:30:35 CDT
>
>Now I see how to examine this as a non-guru:
>
>
>run in archivelog mode.
>install LogMiner.
>switch logfile
>run truncate command
>switch logfile
>find the logfile just archived
>
>run the logminer proc to examine the recently generated logfile.
>You'll see all of the (including recursive) DDL/DML that was executed to
>accomplish the change.
>
>saw it at IOUG - Joe Testa gave a great presentation on the LogMiner
>101.
>didn't see the advanced presentation.
>
>the paper should be at the IOUG site at http://www.ioug.org
>