Home » RDBMS Server » Server Administration » change from nologging to logging (10.2.0.1)
change from nologging to logging [message #545124] Mon, 27 February 2012 07:04 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
How to change the attributes of a table from nologging to logging?
SQL> select table_name,LOGGING from dba_tables where owner='HXL';

TABLE_NAME                     LOG
------------------------------ ---
TB_OBJECTS                     NO

SQL> alter table hxl.tb_test logging;

Table altered.

SQL> select table_name,LOGGING from dba_tables where owner='HXL';

TABLE_NAME                     LOG
------------------------------ ---
TB_OBJECTS                     NO
Re: change from nologging to logging [message #545126 is a reply to message #545124] Mon, 27 February 2012 07:13 Go to previous messageGo to next message
ThomasG
Messages: 3123
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Could it be that that is an external or temporary table?

Please post the result of:

set heading off;
set echo off;
set pages 999;
set long 90000;

select dbms_metadata.get_ddl('TABLE','TB_OBJECTS') 
  from dual;
Re: change from nologging to logging [message #545127 is a reply to message #545124] Mon, 27 February 2012 07:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Maybe my eyes are deceiving me.
You altered hxl.tb_test and are looking at hxl.tb_objects.
Re: change from nologging to logging [message #545129 is a reply to message #545127] Mon, 27 February 2012 07:32 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,

  CREATE TABLE "HXL"."TB_OBJECTS"
   (    "OWNER" VARCHAR2(30),
        "OBJECT_NAME" VARCHAR2(128),
        "SUBOBJECT_NAME" VARCHAR2(30),
        "OBJECT_ID" NUMBER,
        "DATA_OBJECT_ID" NUMBER,
        "OBJECT_TYPE" VARCHAR2(19),
        "CREATED" DATE,
        "LAST_DDL_TIME" DATE,
        "TIMESTAMP" VARCHAR2(19),
        "STATUS" VARCHAR2(7),
        "TEMPORARY" VARCHAR2(1),
        "GENERATED" VARCHAR2(1),
        "SECONDARY" VARCHAR2(1)
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TPS_HXL"
Re: change from nologging to logging [message #545130 is a reply to message #545129] Mon, 27 February 2012 07:33 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!
Previous Topic: To reduce number of datafiles in tablespace
Next Topic: Move partition to cache
Goto Forum:
  


Current Time: Sat Dec 20 16:36:38 CST 2014

Total time taken to generate the page: 0.12514 seconds