Message-Id: <10739.126525@fatcity.com> From: Jacques Kilchoer Date: Fri, 12 Jan 2001 09:24:05 -0800 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_01C07CBC.768E0A50 Content-Type: text/plain; charset="iso-8859-1" >-----Original Message----- >From: Bunyamin K.Karadeniz [mailto:bunyamink@havelsan.com.tr] >Sent: vendredi, 12. janvier 2001 06:56 > >CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED > >MESSAGE IS DISPLAYED WHEN I want to import a huge table; >What must I do??? Thanks Doesn't it mean that some of the logs need to be manually archived? Try typing in "archive log list" in svrmgr. Do you see the following? SVRMGR> archive log list Database log mode Archive Mode Automatic archival Disabled If Automatic archival is disabled you may need to do an "alter system archive log" (read the documentation for the correct syntax. e.g. SVRMGR> alter system archive log all ; ------ any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer. Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com ------_=_NextPart_001_01C07CBC.768E0A50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED error

>-----Original Message-----
>From: Bunyamin K.Karadeniz [mailto:bunyamink@havelsan.com.= tr]
>Sent: vendredi, 12. janvier 2001 06:56
>
>CAN NOT ALLOCATE LOG,ARCHIVAL REQUIRED
>
>MESSAGE IS DISPLAYED WHEN I want to import a = huge table;
>What must I = do???            = Thanks

Doesn't it mean that some of the logs need to be = manually archived? Try typing in "archive log list" in = svrmgr. Do you see the following?

SVRMGR> archive log list
Database log mode Archive Mode
Automatic archival Disabled

If Automatic archival is disabled you may need to do = an "alter system archive log" (read the documentation for the = correct syntax.

e.g.
SVRMGR> alter system archive log all ;

------
any ignorant comments made are the sole = responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com