By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 2,042 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Two questions about "alter table tbname activate not logged initially"

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Daniel Chou wrote:
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"? Not anymore in V8. Any table that satisfies some core requirement can do
this (IIRC there are limitations about RI mostly) 2. After using "alter table tbname activate not logged initially",
how to deactivate it?

Not logged is in effect until the next commit.

Cheers
Serge
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.