operations
are not affected.
On 10/22/2003 04:39:34 PM, Roger Xu wrote:
Hi Gurus,
I have a couple of questions regarding nologging.
1) alter table tabname move tablespace tbsname nologging;
How come this sql still generated same amount of redo logs equal
to the size of the table
Hi Gurus,
I have a couple of questions regarding nologging.
1) alter table tabname move tablespace tbsname nologging;
How come this sql still generated same amount of redo logs equal to the size of
the table?
2) alter index idxname rebuild tablespace tbsname nologging
/2003 04:39:34 PM, Roger Xu wrote:
Hi Gurus,
I have a couple of questions regarding nologging.
1) alter table tabname move tablespace tbsname nologging;
How come this sql still generated same amount of redo logs equal
to the size of the table?
2) alter index idxname rebuild tablespace
operations
are not affected.
On 10/22/2003 04:39:34 PM, Roger Xu wrote:
Hi Gurus,
I have a couple of questions regarding nologging.
1) alter table tabname move tablespace tbsname nologging;
How come this sql still generated same amount of redo logs equal
to the size
that prebuild blocks and add
them below the flood watermark. That includes sqlloader with direct=y,
inserts with /*+ append */ hint and CTAS. Normal SQL based operations
are not affected.
On 10/22/2003 04:39:34 PM, Roger Xu wrote:
Hi Gurus,
I have a couple of questions regarding
A quick look at the docs for 'alter index' will reveal all.
Roger Xu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/22/2003 04:05 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: questions regarding
.
On 10/22/2003 04:39:34 PM, Roger Xu wrote:
Hi Gurus,
I have a couple of questions regarding nologging.
1) alter table tabname move tablespace tbsname nologging;
How come this sql still generated same amount of redo logs equal
to the size of the table?
2) alter index idxname
with /*+ append */ hint and CTAS. Normal SQL based operations
are not affected.
On 10/22/2003 04:39:34 PM, Roger Xu wrote:
Hi Gurus,
I have a couple of questions regarding nologging.
1) alter table tabname move tablespace tbsname nologging;
How come this sql still generated same amount of redo
with direct=y,
inserts with /*+ append */ hint and CTAS. Normal SQL based operations
are not affected.
On 10/22/2003 04:39:34 PM, Roger Xu wrote:
Hi Gurus,
I have a couple of questions regarding nologging.
1) alter table tabname move tablespace tbsname nologging;
How come this sql
PM, Roger Xu wrote:
Hi Gurus,
I have a couple of questions regarding nologging.
1) alter table tabname move tablespace tbsname nologging;
How come this sql still generated same amount of redo logs equal
to the size of the table?
2) alter index idxname rebuild tablespace tbsname
10 matches
Mail list logo