truncate command not working
truncate command is not working in 11g on solaris 10. insert,update,delete and all other commands are working but none of the table can be truncated.
{
SQL*Plus: Release 9.0.1.3.0 - Production on Sun Feb 24 11:39:27 2013
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table ism_test ( no number);
Table created.
SQL> insert into ism_test values(2);
1 row created.
SQL> truncate table ism_test;
truncate table ism_test
*
ERROR at line 1:
ORA-00372: file 8 cannot be modified at this time
SQL> select STATUS,ONLINE_STATUS from DBA_DATA_FILES where FILE_ID=8;
STATUS ONLINE_
--------- -------
AVAILABLE OFFLINE
SQL> select TS#,STATUS,ENABLED from V$DATAFILE where FILE#=8;
TS# STATUS ENABLED
---------- ------- ----------
5 OFFLINE READ WRITE
SQL> select STATUS,CONTENTS from DBA_TABLESPACES where TABLESPACE_NAME = (select TABLESPACE_NAME fro
m DBA_DATA_FILES where FILE_ID=8);
STATUS CONTENTS
--------- ---------
ONLINE PERMANENT
}
Edited by: user11976716 on Feb 24, 2013 1:21 AM