| change from nologging to logging [message #545124] |
Mon, 27 February 2012 07:04  |
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  |
ThomasG
Messages: 3211
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 #545129 is a reply to message #545127] |
Mon, 27 February 2012 07:32 |
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"
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
