oracle nologging mode --- Help, please# Database - 数据库
h*u
1 楼
I want to dump huge amount of data to oracle without writing redo log.
What I do is: change table to nologging mode, then use insert /*+ append */
into table nologging values (....).
But it STILL write the redo log. The log eventually halts the oracle. What
should I do? I don't want to use SQL*loader, either.
Help, please
What I do is: change table to nologging mode, then use insert /*+ append */
into table nologging values (....).
But it STILL write the redo log. The log eventually halts the oracle. What
should I do? I don't want to use SQL*loader, either.
Help, please