RE: A Question asked in OCP Exam..

I know I am asking for trouble, since i am not testing it myself, still...

I understand that in the case of a read-only tablespace only operations that involve only the data dictionary are permitted. As dropping the table modifies only the DD, it works. But I suppose that space management operations are to be performed even in the case of read-only tablespace. If it is dictionary managed, no problem. What if it is a locally managed one? The original question doesn't specify what kind of tablespace we are dealing with. Is it possible to drop a table from a read-only locally managed tablespace? Can a locally managed tablespace be made read-only? I was unable to find the answers in the manuals.

Inquiring minds.....(or was it idle minds?)

Dr. Nikolay Kumanov

MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:nkumanov_at_zgb.bg

"Show me a completely smooth operation and I'll show you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune" Received on Thu Jan 25 2001 - 12:15:32 CST