Message-Id: <10739.126512@fatcity.com> From: David Barbour Date: Fri, 12 Jan 2001 10:34:55 -0600 Subject: RE: CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error 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@connectsouth.com -----Original Message----- From: Bunyamin K.Karadeniz [mailto:bunyamink@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"

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@connectsouth.com

-----Original Message-----
From: Bunyamin K.Karadeniz [mailto:bunyamink@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 İS DİSPLAYED WHEN I want to import a huge table;

What must I do??? Thanks