Advantages
speed
no impact on redo logs
Disadvanges
must take a backup after to avoid reload
- "Dash, Saroj (CAP,CEF)"
<Saroj.Dash_at_gecapital.com> a écrit : >
> 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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Received on Wed Nov 22 2000 - 04:04:42 CST
