RE: Re: export problem ???
oraora - I doubt that Import did insert that record. The message says it skipped that record. Check the table to see whether it was inserted. What did you set for the parameter IGNORE? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 18, 2002 4:19 AM To: Multiple recipients of list ORACLE-L Thanx guys for all your guidance. Thanx Adar. i found that an index on table 17 caused all the delay and took a long time to be created. when i said IMP FILE=ABC.DAT INDEXES=N ROWS=Y i was able to get all the tables. but still,while importing i get the error IMP-00019: row rejected due to ORACLE error 1401 IMP-3: ORACLE error 1401 encountered ORA-01401: inserted value too large for column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++ Column 5 candy this causes a few rows to be skipped in some table. - ORA-01401: inserted value too large for column - if this is true , it should not have allowed that particular row to be inserted while doing INSERT ? why does this occur while importing ? can someone explain me ? TIA. Jp. On Tue, 17 Dec 2002 Yechiel Adar wrote : Hello After building a table the import builds constraint and indexes. If you got a big table that can take awhile. Check with task/performance monitor if the instance is idle or working. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:28 AM guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING. But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Re: export problem ???
oraora, Did the original export come from a database that you have access to? Check the description on the table that had failed to insert some rows. The original source table has different sizes on the columns than the tables you are importing into, That is why some records are getting rejected as ORA-01401: inserted value too large for column Ron [EMAIL PROTECTED] 12/18/02 07:27AM oraora - I doubt that Import did insert that record. The message says it skipped that record. Check the table to see whether it was inserted. What did you set for the parameter IGNORE? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 18, 2002 4:19 AM To: Multiple recipients of list ORACLE-L Thanx guys for all your guidance. Thanx Adar. i found that an index on table 17 caused all the delay and took a long time to be created. when i said IMP FILE=ABC.DAT INDEXES=N ROWS=Y i was able to get all the tables. but still,while importing i get the error IMP-00019: row rejected due to ORACLE error 1401 IMP-3: ORACLE error 1401 encountered ORA-01401: inserted value too large for column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++ Column 5 candy this causes a few rows to be skipped in some table. - ORA-01401: inserted value too large for column - if this is true , it should not have allowed that particular row to be inserted while doing INSERT ? why does this occur while importing ? can someone explain me ? TIA. Jp. On Tue, 17 Dec 2002 Yechiel Adar wrote : Hello After building a table the import builds constraint and indexes. If you got a big table that can take awhile. Check with task/performance monitor if the instance is idle or working. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:28 AM guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING. But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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
Re: Export problem
[EMAIL PROTECTED] wrote: Hi! Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically it should work. EXP-8: ORACLE error 942 encountered ORA-00942: Tabelle oder View nicht vorhanden EXP-00024: Export views not installed, please notify your DBA EXP-0: Export terminated unsuccessfully But why am I getting these error messges? What scripts need to be run to solve this problem? This is 7.3.3 / 8.1.7 on Win NT. Thanks, Helmut i think you need to create the 8.1.7 views in the 7.3.3 database to have the 8.1.7 export work. but i'm not sure that can be done due to the differences in things like rowid and file numbering. but maybe i'm wrong. it should be the catexp[817?].sql script you need to run. -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The generation of random numbers is too important to be left to chance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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: Export problem
But why would you want to? If you export using the 7.3.3 database using the 7.3.3 export utility you should be able to import it into your 8.1.7 database using the 8.1.7 import utility. It's backward compatible. You just can't go the other way (import an 8.1.7 export to 7.3.3). Jay Miller -Original Message- Sent: Tuesday, May 21, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Hi! Can I export a 7.3.3 database with a 8.1.7 export utility? Theoretically it should work. EXP-8: ORACLE error 942 encountered ORA-00942: Tabelle oder View nicht vorhanden EXP-00024: Export views not installed, please notify your DBA EXP-0: Export terminated unsuccessfully But why am I getting these error messges? What scripts need to be run to solve this problem? This is 7.3.3 / 8.1.7 on Win NT. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Export Problem - Urgent
You should try changing the nls_lang value on the client to match the server. Rick -Original Message- Sent: Friday, November 30, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hi, I am trying to export a data from server and getting following error message: EXP-00041: Export done in server's WE8ISO8859P1, different from user's character set US7ASCII EXP-0: Export terminated unsuccessfully How do I fix a problem. My environment is SUN OS 5.6 and Oracle 8.1.6 and trying to export from server itself but still getting error message. Thanks, Meghdeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MRaval 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: Cale, Rick T (Richard) 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: EXPORT problem
Kevin, connect as internal and run @?/rdbms/admin/catproc and then try to export again .. Deepak PS: picked up off of ML --- Kevin Bass [EMAIL PROTECTED] wrote: UNIX help needed for sed multi-line pattern spaceI have just started working at a company and the database has never been backed up since it was created. I am now performing an EXPORT of the database and I am experiencing an EXPORT problem that I have never encountered. Has anyone encountered this problem? EXP-8: ORACLE error 1008 encountered ORA-01008: not all variables bound . . exporting table MP30_WTF EXP-8: ORACLE error 1008 encountered . . exporting table MP30_WUT EXP-8: ORACLE error 1008 encountered . . exporting table MP30_WUT EXP-8: ORACLE error 1008 encountered . . exporting table MP30_WUT EXP-8: ORACLE error 1008 encountered ORA-01008: not all variables bound . . exporting table MP30_WUX EXP-8: ORACLE error 1008 encountered ORA-01008: not all variables bound . . exporting table MP30_XAE . . . Kevin __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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: Export Problem
Just set your NLS_LANG at a command prompt:. This is an example. NLS_LANG=American_America.US7ASCII export NLS_LANG HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 31, 2001 12:23 PM Hi List, I have problem with export, when I try to run EXP got this error msg: Any Idea ?? Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production EXP-00041: Export done in server's US7ASCII, different from user's character set WE8ISO8859P1 EXP-0: Export terminated unsuccessfully -- Finished at: Thu 08/30/2001 5:07p Hamid Alavi Office 818 737-0526 Cell818 402-1987 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. -- 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: Ruth Gramolini 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: Export Problem
From MetaLink Error: EXP 41 Text: Export done in server's %s, different from user's character set %s --- Cause: The specified NLS_LANG/NLS_NCHAR parameter is incompatible with the value specified for the server in props$. Action: Change the client's value for NLS_LANG/NLS_NCHAR to server's value and retry the operation. Rick -Original Message- Sent: Friday, August 31, 2001 12:23 PM To: Multiple recipients of list ORACLE-L Hi List, I have problem with export, when I try to run EXP got this error msg: Any Idea ?? Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production EXP-00041: Export done in server's US7ASCII, different from user's character set WE8ISO8859P1 EXP-0: Export terminated unsuccessfully -- Finished at: Thu 08/30/2001 5:07p Hamid Alavi Office 818 737-0526 Cell818 402-1987 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. -- 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: Cale, Rick T (Richard) 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: EXPORT PROBLEM
MALA, in the export log (typial) this is the order. exporting job queues exporting refresh groups and children exporting user history table exporting default and system auditing options Export terminated successfully without warnings. What you have to do is after importing you have to create refresh groups etc.whatever written above.I am suspecting about the parameter job_queue_processes etc in your init.ora file .I am not sure anyway.Otherwise w.r.t. queues there might be some problem in your database. So don't have to worry about all these .Just import from the dump and do the above.The dump is OK Cheers GAnti --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you We reserve the right to monitor all e-mail communications through our network -- 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: EXPORT PROBLEM
Hi Mala, If you're on 8.1.6 it's a bug. If you do your export without the consistent parameter it should finish okay but you should patch your current installation. --- mala singh [EMAIL PROTECTED] wrote: Hi DBAs I have problem at time of full export of Database.The following are the error message at end of full export. EXP-8: ORACLE error 1403 encountered ORA-01403: no data found ORA-06512: at "SYS.DBMS_IJOB", line 450 ORA-06512: at "SYS.DBMS_IJOB", line 482 ORA-06512: at line 1 EXP-0: Export terminated unsuccessfully Please help. Thanks in advance. -Mala _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala singh 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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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: EXPORT PROBLEM
I am using 8.1.7.I think this is bug.What isur view -Mala From: Rocky Welch [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: EXPORT PROBLEM Date: Wed, 28 Feb 2001 11:45:51 -0800 Hi Mala, If you're on 8.1.6 it's a bug. If you do your export without the consistent parameter it should finish okay but you should patch your current installation. --- mala singh [EMAIL PROTECTED] wrote: Hi DBAs I have problem at time of full export of Database.The following are the error message at end of full export. EXP-8: ORACLE error 1403 encountered ORA-01403: no data found ORA-06512: at "SYS.DBMS_IJOB", line 450 ORA-06512: at "SYS.DBMS_IJOB", line 482 ORA-06512: at line 1 EXP-0: Export terminated unsuccessfully Please help. Thanks in advance. -Mala _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala singh 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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala singh 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: EXPORT PROBLEM
I hate to say it but consult the metalink. That's how I found out about it on 8.1.6. --- mala singh [EMAIL PROTECTED] wrote: I am using 8.1.7.I think this is bug.What isur view -Mala From: Rocky Welch [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: EXPORT PROBLEM Date: Wed, 28 Feb 2001 11:45:51 -0800 Hi Mala, If you're on 8.1.6 it's a bug. If you do your export without the consistent parameter it should finish okay but you should patch your current installation. --- mala singh [EMAIL PROTECTED] wrote: Hi DBAs I have problem at time of full export of Database.The following are the error message at end of full export. EXP-8: ORACLE error 1403 encountered ORA-01403: no data found ORA-06512: at "SYS.DBMS_IJOB", line 450 ORA-06512: at "SYS.DBMS_IJOB", line 482 ORA-06512: at line 1 EXP-0: Export terminated unsuccessfully Please help. Thanks in advance. -Mala _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala singh 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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mala singh 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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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).