Re: Archival Log
From: raghu <raghu1ra_at_rediffmail.com>
Date: 11 Feb 2002 06:29:32 -0800
Message-ID: <d11b9387.0202110629.2eda9792_at_posting.google.com>
Date: 11 Feb 2002 06:29:32 -0800
Message-ID: <d11b9387.0202110629.2eda9792_at_posting.google.com>
saggi_at_sawaal.com (saggi) wrote in message news:<8409c7bb.0202110259.47890950_at_posting.google.com>...
> hi,
> i don't want to create Archive or redo log for my
> temprory tables.
> if posiible, how can i do it ?
>
> thank in adv.
> saggi
> saggi_at_sawaal.com
create the temporary tables in temporary tablespace and also at the
time of creation of the temporary table include the NOLOGGING clause
at the end of the create statement or even at the tablespace level.
regards
Raghu Ram
Certified DBA
Received on Mon Feb 11 2002 - 15:29:32 CET