Alter Table Nologging Oracle 11g. SQL insert APPEND into big_table 2 select from all_objects where rownum 50. CREATE TABLE and ALTER TABLE.
So we use that table with NO logging option so that it will generate less log. Script for alter table in logging mode. It is important to note that just because an index or a table was created with NOLOGGING does not mean that redo generation has been stopped for this table or index.
Begin for r in select table_name from dba_tables where ownerHR and loggingNO loop execute immediate alter table hr rtable_name LOGGING.
CREATE TABLE lob_tab id NUMBER data CLOB LOBdata STORE AS SECUREFILE DISABLE STORAGE IN ROW. SQL archive log list. The same applies for CREATE INDEX but for CREATE TABLE the NOLOGGING should come after the table. Only the following operations can make use of nologging.
