On Thu, 3 Mar 2005 12:49:24 -0400, Juan Carlos Reyes Pacheco <juancarlosreyesp@(protected)> wrote: > Hi carmen, move to a tablespace, and make it read only.
what like this? read only doesn't necessarily mean what you think.
SQL>drop tablespace test including contents and datafiles;
Tablespace dropped.
SQL>create tablespace test 2 datafile 'c:\oracle\product\10.1.0\oradata\test.dbf' size 10m ;
Tablespace created.
SQL>CREATE TABLE T1(C1 NUMBER) 2 TABLESPACE TEST;
Table created.
SQL>CREATE INDEX IDX1 ON T1(C1) TABLESPACE TEST;
Index created.
SQL>BEGIN 2 FOR I IN 1..1000 3 loop 4 EXECUTE IMMEDIATE ' INSERT INTO T1 VALUES (:1)' USING I; 5 END loop; 6 end; 7 /
PL/SQL procedure successfully completed.
SQL>commit;
Commit complete.
SQL>ALTER TABLESPACE TEST READ ONLY;
Tablespace altered.
SQL>insert into test values (3); insert into test values (3) * ERROR at line 1: ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist
SQL>insert into t1 values (3); insert into t1 values (3) * ERROR at line 1: ORA-00372 (See ORA-00372.ora-code.com): file 7 cannot be modified at this time ORA-01110 (See ORA-01110.ora-code.com): data file 7: 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\TEST.DBF'
