Hello All,
Archive log is creating, even if the tablespace,table are in NOLOGGING. And also i am trying to create a table using CATS (create table test_table AS Select...)
Database Version : Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
alter tablespace DATA11 NOLOGGING;
alter session enable parallel dml;
create table test_table
tablespace DATA11
Parallel (degree 8)
NolOGGING
AS
SELECT /* + append */
CREATED_BY,
CREATED,
....
....
FROM
Table_1;
Table_1 : 50M rows
it is creating huge archive. Any possible way to avoid creating archivelogs? other than "alter database noarchivelog"