I think it will not do it. If I make a tablespace read only than DML will fail before I even get to commit.
Any other idea?
1* ALTER TABLESPACE psdefault read only
HCMDEV:SYSTEM> /
Tablespace altered.
HCMDEV:SYSTEM>
HCMDEV:SYSTEM> insert into ORACLETEST values ('11111');
insert into ORACLETEST values ('11111')
*
ERROR at line 1:
ORA-00372: file 3 cannot be modified at this time
ORA-01110: data file 3: '/u03d/oradata/HCMDEV/psdefault.dbf'
Last edited by BV1963; 11-03-2005 at 01:55 PM.
One, who thinks that the other one who thinks that know and does not know, does not know either!
Reply With Quote