Hi Nikolaly,
No.. you are not asking for trouble.. Here is the answer..
I ran the test on 8.1.7 database on AIX.
TABLESPACE_NAME EXTENT_MAN
------------------------------ ----------
CAMPAIGNS_MED LOCAL
CAMPAIGNS_SMALL LOCAL
2 rows selected.
SQL> create table test (c number) tablespace campaigns_small;
Table created.
SQL> alter tablespace campaigns_small read only;
Tablespace altered.
SQL> drop table test;
Table dropped.
SQL>
Hope this helps..
- Kirti Deshpande
Verizon Information Services
> -----Original Message-----
> From: Nikolay Kumanov [SMTP:nkumanov_at_zgb.bg]
> Sent: Thursday, January 25, 2001 12:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
Received on Thu Jan 25 2001 - 13:03:46 CST
