RE: Re: export problem ???

2002-12-18 Thread Ron Rogers
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 a

RE: Re: export problem ???

2002-12-18 Thread DENNIS WILLIAMS
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, Dece

RE: Export problem

2002-05-21 Thread Miller, Jay
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

Re: Export problem

2002-05-21 Thread bill thater
[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:

RE: Export Problem - Urgent

2001-11-30 Thread Cale, Rick T (Richard)
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: Exp

Re: EXPORT problem

2001-11-16 Thread Kevin Bass
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: pi

Re: EXPORT problem

2001-11-15 Thread Deepak Thapliyal
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 ba

RE: Export Problem

2001-08-31 Thread Cale, Rick T (Richard)
>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

Re: Export Problem

2001-08-31 Thread Ruth Gramolini
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

Re: EXPORT PROBLEM on 8.1.7

2001-06-08 Thread Connor McDonald
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_FU

Re: EXPORT PROBLEM

2001-03-02 Thread GANTI . SIVA
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 crea

Re: EXPORT PROBLEM

2001-03-01 Thread mala singh
.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 &

Re: EXPORT PROBLEM

2001-03-01 Thread GANTI . SIVA
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

Re: EXPORT PROBLEM

2001-02-28 Thread Rocky Welch
OTECTED] > >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 pa

Re: EXPORT PROBLEM

2001-02-28 Thread mala singh
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

Re: EXPORT PROBLEM

2001-02-28 Thread Rocky Welch
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 >

Re: EXPORT PROBLEM

2001-02-28 Thread Ruth Gramolini
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" <[EM