Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> LOCKING ON THE UET$ TABLE
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