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 -> LOCKING ON THE UET$ TABLE

LOCKING ON THE UET$ TABLE

From: JJ RONE <jjrone_at_my-deja.com>
Date: Wed, 10 Nov 1999 23:32:19 GMT
Message-ID: <80cva3$mb1$1@nnrp1.deja.com>


 I am trying to delete some materialized views so that I can move the datafiles over to another Unix Box instead of doing an export.

The Problem is that I have to eliminate the materialized views on the current database. This has not been a problem for the smaller snapshots (materialized views), but the larger ones seem to keep the table "UET$" locked with a disk Space transaction as the Lock type.

I cannot find any reference to this table in the Documentation and I have also not encountered a 'disk space transaction' lock before to my knowledge.

In any case, I am looking for a little help. Anyone know anything about this table. Moving the data will get done regardless.

Thanks

--
JJ RONE
JUST TRYIN TO KEEP THE DATABASE UP
FOR AMERICAS FREEDOM Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 10 1999 - 17:32:19 CST

Original text of this message

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