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
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
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
[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:
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
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
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
>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
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
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
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
.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 &
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
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
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
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
>
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
17 matches
Mail list logo