| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: UNrecoverable .....................
Hi Saroj
It will not log the insert data into the online redo logs.
The speed of your insert would be much quicker because it
would not write to the redo logs.
If you need to recover you cannot recover this
transcation because nothing is logged in the online redo logs
and hence the archive logs.
HTH Best Regards
Suhen Pather
Oracle DBA
Strandbags (Australia)
02 9479 7791
email suhen.pather_at_strandbags.com.au
-----Original Message-----
From: Dash, Saroj (CAP,CEF) [mailto:Saroj.Dash_at_gecapital.com]
Sent: Wednesday, 22 November 2000 12:25
To: Multiple recipients of list ORACLE-L
Subject: UNrecoverable .....................
Hi,
What is the advantage of using Unrecoverable table. suppose i want to insert data into a table through a sql loader,then i write the control file syntax like thing. Please tell me what is the advantage of using this control files.
Unrecoverable
Load data
truncate into table xyz
blah
blah
...
I came to know these are tha advantages
space is saved in the redo log file.
time is decreased.
perfoemance improves
tell me in detail disadvantage and advantage.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj (CAP,CEF)
INET: Saroj.Dash_at_gecapital.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 21 2000 - 21:48:32 CST
 |
 |