Hello,

I have two questions about "not logged initially":

1. Before using "alter table tbname activate not logged initially",
should the table be created with "not logged initially"?

2. After using "alter table tbname activate not logged initially",
how to deactivate it?

Thanks a lot.

Daniel Chou wrote:
[color=blue]
> Hello,
>
> I have two questions about "not logged initially":
>
> 1. Before using "alter table tbname activate not logged initially",
> should the table be created with "not logged initially"?[/color]
Not anymore in V8. Any table that satisfies some core requirement can do
this (IIRC there are limitations about RI mostly)[color=blue]
> 2. After using "alter table tbname activate not logged initially",
> how to deactivate it?[/color]
Not logged is in effect until the next commit.

Cheers
Serge