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 R
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: 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
[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 - 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
Thanks! That resolved the problem. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 15, 2001 8:10 PM > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Bass 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
>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
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 on 8.1.7
Check out metalink, - its most probably mismatch between export versions (and catexp in particular), but there have been bugs in the past as well which caused 904's... hth connor --- Arslan Dar <[EMAIL PROTECTED]> wrote: > > Hi there > > I am doing a USER LEVEL export as a user with > EXP_FULL_DATABASE role > from oracle 8.1.6 HOST > using a remote machine (which have 8.1.7) through > command line (EXP > command). > i am getting following error > > EXP-8 : Oracle error 904 encountered > ORA-00904 : invalid column name > > > > EXP-8 : Oracle error 1003 encountered > ORA-01003 : no statement parsed > ... > > AND at the end of the export > > EXP-8: ORACLE error 6550 encountered > ORA-06550: line1, column 29 > PLS-00302: component 'IS_TRIGGER_FIRE_ONCE_INTERNAL' > must be declared > ORA-06550: line1, column 8 > PL/SQL : Statement Ignored > EXP-00056: ORACLE error 1403 encountered > ORA-1403 : no data found > EXP-0: Export terminated unsuccessfully > > I tried it with the user SYS but same error comes, > > The difference is b/w the versions of oracle , one > is 8.1.6 (SOURCE) and > other is 8.1.7 (client) > > > Where do I go from here? > Awaiting your speedy reply. > > Arslan Zaheer Dar > > = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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
Ganti The oracle version is 8.1.7 and The export script is exp userid=system/xx full=Y consistent=Y file=abc.dmp log=abc.log The error came at end of export error message is ". exporting job queues 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" Hope this you are looking for. Thanks -Mala >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: EXPORT PROBLEM >Date: Thu, 01 Mar 2001 02:15:48 -0800 > > >Mala, > >Please don't jump into conclusion about the bug.I also made a mistake like >this before.What is the database version you are using. >If it is 8.1.6 >can you please send your export script and your init.ora file so that i can >do >something > >Cheers >Ganti >-- >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). _ 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
Mala, Please don't jump into conclusion about the bug.I also made a mistake like this before.What is the database version you are using. If it is 8.1.6 can you please send your export script and your init.ora file so that i can do something Cheers Ganti -- 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
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).
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
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
Have you run the catexp script as sys? It is in ORACLE_HOME/rdbms/admin. If you have not run catalog run that first, then catproc and catexp. If you have run the above, did you set your ORACLE_SID? Just a thot, rUTH - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 1:00 PM > 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). -- 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).
