Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: truncate hangs for a long time

Re: truncate hangs for a long time

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Jun 2005 06:39:48 -0700
Message-ID: <1118410788.695204.110250@z14g2000cwz.googlegroups.com> 





If the table was in use then the truncate command would have returned
an ORA-00054 error at for any version up to and including 9.2



The fact sys.mlog$ is also locked makes me wonder if this table is
involved in replication (materialized view)?  And if so, what kind of
refresh is in use?



HTH -- Mark D Powell --
Received on Fri Jun 10 2005 - 08:39:48 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US