RE: CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error

From: David Barbour <dbarbour_at_connectsouth.com>
Date: Fri, 12 Jan 2001 10:34:55 -0600
Message-Id: <10739.126512@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07CB5.98BEA690
Content-Type: text/plain;

charset="iso-8859-1"

Manually archive your redo logs. Sounds like you're in archive mode, but you haven't started automatic archiving. Depending on which logs you want to archive, you can use various options. To archive all full groups, try:

ALTER SYSTEM ARCHIVE_LOG ALL; David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Bunyamin K.Karadeniz [mailto:bunyamink_at_havelsan.com.tr] Sent: Friday, January 12, 2001 8:56 AM
To: Multiple recipients of list ORACLE-L Subject: CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error

CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED MESSAGE IS DISPLAYED WHEN I want to import a huge table;

What must I do??? Thanks

------_=_NextPart_001_01C07CB5.98BEA690
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=905352916-12012001><FONT face=Arial color=#0000ff
size=2>Manually archive your redo logs.  Sounds like you're in archive mode, but you haven't started automatic archiving.  Depending on which logs you want to archive, you can use various options.  To archive all full groups, try:</FONT></SPAN></DIV>
<DIV><SPAN class=905352916-12012001><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=905352916-12012001>    <FONT face=Arial
color=#0000ff size=2>ALTER SYSTEM ARCHIVE_LOG ALL;</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT face=Arial size=2>David A. Barbour</FONT> <BR><FONT face=Arial

size=2>Oracle DBA - ConnectSouth</FONT> <BR><FONT face=Arial 
size=2>512-681-9438</FONT> <BR><FONT face=Arial 
size=2>dbarbour_at_connectsouth.com</FONT> </P>

<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Bunyamin K.Karadeniz [mailto:bunyamink_at_havelsan.com.tr]<BR><B>Sent:</B> Friday, January 12, 2001 8:56 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error<BR><BR></FONT></DIV>

  <DIV><FONT face="MS Sans Serif" size=1>
  <P><FONT color=#008000><STRONG><EM>CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED 
  </EM></STRONG></FONT></P>
  <P>&nbsp;</P>
  <P>MESSAGE &#304;S D&#304;SPLAYED WHEN I want to import a huge table;</P>
  <P>What must I

do???            Thanks</P></FONT></DIV></BLOCKQUOTE></BODY></HTML> Received on Fri Jan 12 2001 - 10:34:55 CST