Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tablespace in read only

864103Nov 15 2011 — edited Nov 15 2011
hi all

can you advice in this

i create tablepsace and i altered to read only and i alter user scott to make the

default tablespace to scott this tablespace (read only) i know the tablespace in read only

prevent writing the operation in datafile that belong to that tablespace

when i conn with scott when i create table the error message appear the tablespace in read only

this is true but when i try to to any dml statement on any table in scott schema this will complete

without error is this happen due the scott schema in users tablespace and every data in users
tablespace can modify it ??? can you explain ?


MANY THANKS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2011
Added on Nov 15 2011
10 comments
977 views