Hi,
I have enough free disk space on my archive_log_dest
volume (3GB). That error message appeared when
importing tables with large size (more than 300,000
rows).
Thanks,
John.
--- Winnie_Liu_at_infonet.com wrote:
>
> Jeff is right. You are definitely out of space in
> your archive dest. Oracle
> stop processing as all the redo log buffer is filled
> with information that
> need to flush to the redo log and all the redo log
> is waiting for archive.
>
> Winnie
>
>
>
>
>
> "Jeff Gumpert"
> <Jeff_at_GumpertConsulting.com>@fatcity.com on
> 10/16/2000
> 01:02:48 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
>
>
>
> Do you have enough free disk space on your
> archive_log_dest volume?
>
> Jeff
>
> -----Original Message-----
> Sent: Monday, October 16, 2000 3:32 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello,
> I've got problem with log archival when importing
> data. The following error
> message occured:
> "Warning-The following error occured during Oracle
> redo log archival:
> Oracle Instance dev-Can not allocate log, archival
> requried
> Press <ENTER> to acknowledge message."
>
> Any idea what I could do to avoid that error
> message?
>
> Thanks in advance,
>
> John.
>
>
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
>
> Share information about yourself, create your own
> public profile at
> http://profiles.msn.com.
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: John Phan
> INET: johnphanz_at_hotmail.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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jeff Gumpert
> INET: Jeff_at_GumpertConsulting.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).
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Winnie_Liu_at_infonet.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 Fri Oct 20 2000 - 06:39:00 CDT
