11g, Unable to do nolog operations

From: <lyxx09_at_gmail.com>
Date: Fri, 2 Oct 2009 01:41:37 -0700 (PDT)
Message-ID: <86b8c632-e009-47e8-90bb-bcf5e1b80211_at_g22g2000prf.googlegroups.com>

Hi,

I am using 11g R1 on OEL 4.0, I noticed it's not allowing nolog operations to me even though database and tablespaces are in nologging mode.

I would appreciate if some one have a look.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options

SQL> archive log list

Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/11g/dbs/arch
Oldest online log sequence     9
Current log sequence           10

SQL>
SQL> select force_logging from v$database;

FOR

---
NO

SQL> select tablespace_name,logging from dba_Tablespaces where
  2  contents = 'PERMANENT';

TABLESPACE_NAME                LOGGING
------------------------------ ---------
SYSTEM                         NOLOGGING
SYSAUX                         NOLOGGING
TEST                           NOLOGGING


SQL> conn /
Connected.


SQL> create table T NOLOGGING tablespace test as select * from
dba_objects;

Table created.

SQL>
SQL>
SQL> select name,unrecoverable_time from v$datafile;

NAME                                               UNRECOVER
-------------------------------------------------- ---------


+DG1/test/datafile/system.260.697440875

+DG1/test/datafile/sysaux.265.697440889

+DG1/test/datafile/undotbs1.258.697440903

+DG1/test/datafile/test.261.699167731

Received on Fri Oct 02 2009 - 03:41:37 CDT