Subject:RE: Export/Import Error and Validation !!!
Tracy, I hit the same bug when doing reorg using export/import (Solaris 2.6, Oracle 8.1.7.4) for some tables in our baan erp database. The tables had unique constraints that were failing after the import. Found out that import has changed the values in some unique index columns. The export was done using 10MB buffer size. I didn't notice this issue with 2MB or less buffer size. Oracle support filed a Bug 2594794 "EXPORT GENERATES ORA-1 ERROR WHEN BUFFER SIZE IS LARGE" for it. Regards, Manmohan _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anubha Jalsingh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Export/Import Error and Validation !!!
check out note 199416.1 - talks about export corruption on certain releases.>>> [EMAIL PROTECTED] 1/8/03 2:44:15 PM >>>Tracy Rahmlow wrote:> > We attempted to reorg a table and data corruption resulted. We have isolated> the issue and currently have a tar open with Oracle. But basically, when we> export the table with a buffer=10485760 the import process corrupts the data.> The row count matches, however some fields that initially were null now contain> data (there were some other odd data issues in addition). No errors were> produced during either the export or import process. When we used a> buffer=65536 the table data was correct. This is reproducable. Has anybody> seen this before? (AIX 4.3.3 / Oracle 8.1.7.3) Can the buffer size be set too> high?This is just an idea based on past problems with the OCIs, but arraysize (as in 'array fetch') is limited to 32K (smells of signed shortindex). Your buffer size indirectly specifies the number of rows youreturn with a single batch (something in the order of magnitude ofbuffer / avg_row_len). It is not impossible, if your rows are short,that your theoretical array size is past the limit and that Oracledoesn't handle it properly.-- Regards,Stephane FaroultOriole Software-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephane Faroult INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Export/Import Error and Validation !!!
Tracy Rahmlow wrote: > > We attempted to reorg a table and data corruption resulted. We have isolated > the issue and currently have a tar open with Oracle. But basically, when we > export the table with a buffer=10485760 the import process corrupts the data. > The row count matches, however some fields that initially were null now contain > data (there were some other odd data issues in addition). No errors were > produced during either the export or import process. When we used a > buffer=65536 the table data was correct. This is reproducable. Has anybody > seen this before? (AIX 4.3.3 / Oracle 8.1.7.3) Can the buffer size be set too > high? This is just an idea based on past problems with the OCIs, but array size (as in 'array fetch') is limited to 32K (smells of signed short index). Your buffer size indirectly specifies the number of rows you return with a single batch (something in the order of magnitude of buffer / avg_row_len). It is not impossible, if your rows are short, that your theoretical array size is past the limit and that Oracle doesn't handle it properly. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Export/Import Error and Validation !!!
Could you be hitting bug 2410612 : CONVENTIONAL EXPORT HAS WRONG DATA ON IMPORT? From: "Tracy Rahmlow" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Export/Import Error and Validation !!! Date: Tue, 07 Jan 2003 15:11:16 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc4-f33.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 7 Jan 2003 15:51:57 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id PAA29480;Tue, 7 Jan 2003 15:50:25 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00529564; Tue, 07 Jan 2003 15:11:16 -0800 Message-ID: <[EMAIL PROTECTED]> X-Comment: Oracle RDBMS Community Forum X-Sender: "Tracy Rahmlow" <[EMAIL PROTECTED]> Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 07 Jan 2003 23:51:57.0886 (UTC) FILETIME=[C3B2BDE0:01C2B6A7] We attempted to reorg a table and data corruption resulted. We have isolated the issue and currently have a tar open with Oracle. But basically, when we export the table with a buffer=10485760 the import process corrupts the data. The row count matches, however some fields that initially were null now contain data (there were some other odd data issues in addition). No errors were produced during either the export or import process. When we used a buffer=65536 the table data was correct. This is reproducable. Has anybody seen this before? (AIX 4.3.3 / Oracle 8.1.7.3) Can the buffer size be set too high? In addition, are there any audits that we can employ to catch such an error? For example, row counts were the same prior and post the process. Are there other things that can be checked. How do others validate that a reorg was successful? We were thinking about executing a data compare through sql of the old and newly reorged table. This seems excessive and not practical for very large tables. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Export/Import Error and Validation !!!
Tracy, Have a look at bug 2475331 / 2410612 RDBMS CONVENTIONAL EXPORT HAS WRONG DATA ON IMPORT This is listed as having happened in 8173. Bug has no details of why or who it might affect. 1. Use direct=true and the problem would not reproduce 2. Set the buffer size 100 and the problem would not reproduce. Note 199416.1 has more info: 8170-8172 not affected. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 8 January 2003 10:11 AM We attempted to reorg a table and data corruption resulted. We have isolated the issue and currently have a tar open with Oracle. But basically, when we export the table with a buffer=10485760 the import process corrupts the data. The row count matches, however some fields that initially were null now contain data (there were some other odd data issues in addition). No errors were produced during either the export or import process. When we used a buffer=65536 the table data was correct. This is reproducable. Has anybody seen this before? (AIX 4.3.3 / Oracle 8.1.7.3) Can the buffer size be set too high? In addition, are there any audits that we can employ to catch such an error? For example, row counts were the same prior and post the process. Are there other things that can be checked. How do others validate that a reorg was successful? We were thinking about executing a data compare through sql of the old and newly reorged table. This seems excessive and not practical for very large tables. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Export/Import Error and Validation !!!
We attempted to reorg a table and data corruption resulted. We have isolated the issue and currently have a tar open with Oracle. But basically, when we export the table with a buffer=10485760 the import process corrupts the data. The row count matches, however some fields that initially were null now contain data (there were some other odd data issues in addition). No errors were produced during either the export or import process. When we used a buffer=65536 the table data was correct. This is reproducable. Has anybody seen this before? (AIX 4.3.3 / Oracle 8.1.7.3) Can the buffer size be set too high? In addition, are there any audits that we can employ to catch such an error? For example, row counts were the same prior and post the process. Are there other things that can be checked. How do others validate that a reorg was successful? We were thinking about executing a data compare through sql of the old and newly reorged table. This seems excessive and not practical for very large tables. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Import Error
Hamid, try setting NLS_CHAR=WE8ISO8859P1 in the session doing the import. HTH Ramon - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 11:38 AM > Hi List, > > This morning I try to import a dump file from another database(oracle 8.1.6) > to my database(oracle 8.17.4 sun solaris )but I got the following error, > after I check the error message it said it is an internal error, What do you > think: > > import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set > import server uses US7ASCII character set (possible charset conversion) > IMP-00069: Could not convert to environment national character set's handle > > Is there any solution. > > Thanks. > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > > > > > > === Confidentiality Statement === > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > = End Confidentiality Statement = > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Ramon E. Estevez INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Import Error
Hi List, This morning I try to import a dump file from another database(oracle 8.1.6) to my database(oracle 8.17.4 sun solaris )but I got the following error, after I check the error message it said it is an internal error, What do you think: import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) IMP-00069: Could not convert to environment national character set's handle Is there any solution. Thanks. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Import error from 8.1.7.2.0 to 8.0.5
Could you use the COPY command?
Rick
àãø éçéàì
.co.il> cc:
Sent by: Subject: RE: Import error from 8.1.7.2.0
to 8.0.5
root@fatcity.
com
02/14/2002
07:58 AM
Please
respond to
ORACLE-L
If you can, try to do the export with the 8.0.5 export.
This should eliminate the incompatibility between versions.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
> Sent: Wed, February 13, 2002 10:38 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Import error from 8.1.7.2.0 to 8.0.5
>
>
> Hi All,
>
> I am trying to export a table from one Oracle db (Version 8.1.7.2.0) and
> import into another Oracle db (Version 8.0.5) and I have got the
following
> error during import-
>
> IMP-00069: Could not convert to environment national character set's
> handle
> IMP-00021: operating system error - error code (dec 2, hex 0x2)
> IMP-0: Import terminated unsuccessfully
>
> Request your help/suggestion on the above.
>
> Thanks in advance.
>
> PM
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
åy« ±ç
ê ~'"jS "Ä,PÛiÿü0ÂÚ}ª¢`.¶+ ÑF'$ ©^µæ¦
楶(V
+r5ëp¢¹z»âqë<çÎwó9ÔPó9ßÎtçT8'è®x>æåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq
+ j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨ àØw%¹×)Þríj)â
+I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
RE: Import error from 8.1.7.2.0 to 8.0.5
If you can, try to do the export with the 8.0.5 export. This should eliminate the incompatibility between versions. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wed, February 13, 2002 10:38 AM > To: Multiple recipients of list ORACLE-L > Subject: Import error from 8.1.7.2.0 to 8.0.5 > > > Hi All, > > I am trying to export a table from one Oracle db (Version 8.1.7.2.0) and > import into another Oracle db (Version 8.0.5) and I have got the following > error during import- > > IMP-00069: Could not convert to environment national character set's > handle > IMP-00021: operating system error - error code (dec 2, hex 0x2) > IMP-0: Import terminated unsuccessfully > > Request your help/suggestion on the above. > > Thanks in advance. > > PM > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Import error from 8.1.7.2.0 to 8.0.5
check the national character set are same . This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it.
Re: Import error from 8.1.7.2.0 to 8.0.5
Pls read the Oracle utilities manual,One cannot import the higher version of dump into a lower version of Oracle. You need to run the catexp7.sql in $ORACLE_HOME/rdbms/admin dir in the server to create the export views compatible with lower version of Oracle. Moreover when you post any message in future,pls tell the operating system in which you are trying the same. HTH Regards Venkat -- On Wed, 13 Feb 2002 00:38:21 Pradyut_Mitra wrote: >Hi All, > >I am trying to export a table from one Oracle db (Version 8.1.7.2.0) and >import into another Oracle db (Version 8.0.5) and I have got the following >error during import- > >IMP-00069: Could not convert to environment national character set's >handle >IMP-00021: operating system error - error code (dec 2, hex 0x2) >IMP-0: Import terminated unsuccessfully > >Request your help/suggestion on the above. > >Thanks in advance. > >PM Go Get It! Send FREE Valentine eCards with Lycos Greetings http://greetings.lycos.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Import error from 8.1.7.2.0 to 8.0.5
Hi All, I am trying to export a table from one Oracle db (Version 8.1.7.2.0) and import into another Oracle db (Version 8.0.5) and I have got the following error during import- IMP-00069: Could not convert to environment national character set's handle IMP-00021: operating system error - error code (dec 2, hex 0x2) IMP-0: Import terminated unsuccessfully Request your help/suggestion on the above. Thanks in advance. PM
RE: Import Error.
As usual Mladen's comment is half true and half joke. To identify what is you problem do next: grep 12 /user/include/sys/errno.h and you will get # define ENOMEM 12 /* Not enough core*/ ( see also man errno | grep ENOMEM ) Which means you're out of swap space ( or memory). Regardless of the amount of RAM , unless you've set swapmem_on=1. You must have swap space large enough to map every process whetever in RAM or swapped out ( check swapinfo -tm). As DBA you will not be able to modify kernel and basically you will return to same place as Mladen point to SAM ( or his son - probably means manually build kernel manually without SAM). Give new task to your SA. Hope it helps -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Import Error.
LOLOL...you're a sick one, Mladen! >>> [EMAIL PROTECTED] 05/07/01 01:45PM >>> Increase the available address space through SAM or his son. -Original Message- Sent: Monday, May 07, 2001 7:21 AM To: Multiple recipients of list ORACLE-L Hi Gurus I'm importing a dump of 8.0.5 on a new Oracle installation (8.0.5) on HP UX 10.5. Its giving me the following error for some tables and packages. IMP-00044: unable to allocate enough memory for statement IMP-00021: operating system error - error code (dec 12, hex 0xC) I tried increasing the db_block_buffers.. But it didn't help.. I couldn't find any help in OS specific documentation.. What can I do to solve this.. Thanks in Advance, Manivannan.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Tim Sawmiller INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Import Error.
Increase the available address space through SAM or his son. -Original Message- Sent: Monday, May 07, 2001 7:21 AM To: Multiple recipients of list ORACLE-L Hi Gurus I'm importing a dump of 8.0.5 on a new Oracle installation (8.0.5) on HP UX 10.5. Its giving me the following error for some tables and packages. IMP-00044: unable to allocate enough memory for statement IMP-00021: operating system error - error code (dec 12, hex 0xC) I tried increasing the db_block_buffers.. But it didn't help.. I couldn't find any help in OS specific documentation.. What can I do to solve this.. Thanks in Advance, Manivannan.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Import Error.
Manivannan, This looks like bug 618391 "IMPORT FAILS TO RAISE IMP-44 UNTIL ALL MEMORY IS USED. MEMORY LEAK OR SPIN" Try using a larger value for BUFFER on import. HTH, -- Anita --- "Manivannan.M" <[EMAIL PROTECTED]> wrote: > Hi Gurus > > I'm importing a dump of 8.0.5 on a new Oracle > installation (8.0.5) on HP > UX 10.5. > Its giving me the following error for some tables > and packages. > > IMP-00044: unable to allocate enough memory for > statement > IMP-00021: operating system error - error code (dec > 12, hex 0xC) > > I tried increasing the db_block_buffers.. But it > didn't help.. > > I couldn't find any help in OS specific > documentation.. > > What can I do to solve this.. > > Thanks in Advance, > Manivannan.M > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Manivannan.M > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Import Error.
Hi Gurus I'm importing a dump of 8.0.5 on a new Oracle installation (8.0.5) on HP UX 10.5. Its giving me the following error for some tables and packages. IMP-00044: unable to allocate enough memory for statement IMP-00021: operating system error - error code (dec 12, hex 0xC) I tried increasing the db_block_buffers.. But it didn't help.. I couldn't find any help in OS specific documentation.. What can I do to solve this.. Thanks in Advance, Manivannan.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: IMPORT Error - IMP-00020: long column too large for column bu
Title: RE: IMPORT Error - IMP-00020: long column too large for column buffer size > -Original Message- > From: Antonio Idone [mailto:[EMAIL PROTECTED]] > > i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00 > A 9000/800. > The folling tables Import terminated successfully > > AGG_CTR_SEDE_TRG_R > V_DOC_AGREE_CTR_R > > but : > > . . importing table "AGG_CTR_SEDE_TRG_R" > IMP-00020: long column too large for column buffer size > (2)raoul oracle > > i have used buffer with 64k, 100k, 4M 10M 20M 40M 50M > > 60,80,100M but don't work > > IMP-6: failed to allocate memory of size 1 > IMP-00021: operating system error - error code (dec 2, hex 0x2) > IMP-0: Import terminated unsuccessfully Could it be that your buffer size is getting too large? Here's what the Oracle error messages manual says: IMP-00020: long column too large for column buffer size num Cause: The column buffer is too small. This usually occurs when importing LONG data. Action: Increase the insert buffer size 10,000 bytes at a time up to 66,000 or greater (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem.
RE: IMPORT Error - IMP-00020: long column too large for column bu
if ur table is not hving a long column, it could be bug #230777 the imp file could be corrupted. hv u tried using a fresh new export dump with larger buffersize. then try importing this new export. -Mandar > -Original Message- > From: Antonio Idone [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 23, 2001 4:31 PM > To: Multiple recipients of list ORACLE-L > Subject: IMPORT Error - IMP-00020: long column too large for column > buffer size > > > Hi list, > > i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00 > A 9000/800. > The folling tables Import terminated successfully > > AGG_CTR_SEDE_TRG_R > V_DOC_AGREE_CTR_R > > but : > > . . importing table "AGG_CTR_SEDE_TRG_R" > IMP-00020: long column too large for column buffer size > (2)raoul oracle > > i have used buffer with 64k, 100k, 4M 10M 20M 40M 50M > > 60,80,100M but don't work > > IMP-6: failed to allocate memory of size 1 > IMP-00021: operating system error - error code (dec 2, hex 0x2) > IMP-0: Import terminated unsuccessfully > > thanks > Antonio > __ > _ > Visit http://www.visto.com/info, your free web-based > communications center. > Visto.com. Life on the Dot. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Antonio Idone > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Mandar Ghosalkar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
IMPORT Error - IMP-00020: long column too large for column buffer size
Hi list, i have Import error with Oracle 8.0.5 on HP-UX raoul B.11.00 A 9000/800. The folling tables Import terminated successfully AGG_CTR_SEDE_TRG_R V_DOC_AGREE_CTR_R but : . . importing table "AGG_CTR_SEDE_TRG_R" IMP-00020: long column too large for column buffer size (2)raoul oracle i have used buffer with 64k, 100k, 4M 10M 20M 40M 50M 60,80,100M but don't work IMP-6: failed to allocate memory of size 1 IMP-00021: operating system error - error code (dec 2, hex 0x2) IMP-0: Import terminated unsuccessfully thanks Antonio ___ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Antonio Idone INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
