Re: Logical log for Temp table
- From: bozon <curtis@xxxxxxxxxxxx>
- Date: Tue, 29 Jan 2008 07:07:02 -0800 (PST)
On Jan 29, 5:03 am, falcons...@xxxxxxxxx wrote:
From informix manual, I found that any logical database operation will
be logged in logical log. However, will any logical operation on
temporary table be logged too in logical log. I ask this question as
it is non sense to log logical operation for temp table as it will not
be recovered when recovery is required.
Thanks for any reply.
It depends. If you create the temporary table with logging then it
will log if you create it without logging it won't
Here are the two syntax types:
create temp table(
.....
) with no log;
create temp table(
) ;
select * from <table> into temp <temp table> with no log;
select * from <table> into temp <temp table> ;
.
- References:
- Logical log for Temp table
- From: falconsoon
- Logical log for Temp table
- Prev by Date: Re: Problem with Windows domain users
- Next by Date: Re: GoldenGate?
- Previous by thread: Logical log for Temp table
- Next by thread: Re: Logical log for Temp table
- Index(es):
Relevant Pages
|
|
