OraFAQ Forum: Server Utilities » IMPORT Problem NEED HELP quickly

Home » RDBMS Server » Server Utilities » IMPORT Problem NEED HELP quickly (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMPORT Problem NEED HELP quickly [message #180426]

Mon, 03 July 2006 08:30

shiraifr
Messages: 4
Registered: July 2006

Junior Member

Hello,
I'm working under Oracle 10g 10.1.0.2.0 - 64bit on solaris 5.8 server.

I have an export file "kmaj.dmp" done with the following options :
exp toto/titi FILE=kmaj.dmp LOG=kmaj.log CONSISTENT=Y DIRECT=Y OWNER=toto
And :
echo $NLS_LANG ---> FRENCH_FRANCE.WE8ISO8859P1

The export is ok, no errors.
When i try to import the exported file with :
imp userid=system/passwd FILE=kmaj.dmp LOG=kmaj.log fromuser=kmaj touser=kmaj_restore IGNORE=Y buffer=1000000 tables=kmaj_fmaj

I need to get one table from all exported tables
I have the following error :

IMP-00008: instruction non reconnue dans le fichier d'export:
d4
IMP-00008: instruction non reconnue dans le fichier d'export:
d5
........
. Import d'objets KMAJ dans KMAJ_REST
IMP-00017: Echec de l'instruction suivante avec erreur ORACLE 942 :
IMP-00003: Erreur ORACLE 942 rencontr�e
ORA-00942: Table ou vue inexistanteErreur de segmentation - L'image m�moire a �t� vid�e dans le fichier core.

Thanks for any help.

Report message to a moderator

Re: IMPORT Problem NEED HELP quickly [message #180428 is a reply to message #180426]

Mon, 03 July 2006 08:36

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> I have an export file "kmaj.dmp" done with the following options :
Is that a dump file of lower verion (9i or lower)?
Then, import using a 9i version of imp ( or from an 9i installation into a 10g database using tnsnames service).
And please translate the messages to ENGLISH.

Report message to a moderator

Re: IMPORT Problem NEED HELP quickly [message #180432 is a reply to message #180428]

Mon, 03 July 2006 08:48

shiraifr
Messages: 4
Registered: July 2006

Junior Member

Hi,
The dump file was generated on Oracle 10 "I'm working under Oracle 10g 10.1.0.2.0 - 64bit on solaris 5.8 server."

For the translation :
IMP-00008: unrecognized statement in the export file:

Thanks

Report message to a moderator

Re: IMPORT Problem NEED HELP quickly [message #180435 is a reply to message #180432]

Mon, 03 July 2006 08:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did you transfer/copy/ftp the file across OS or even the same OS?
make sure you transfered with BIN option.
Either Your file is corrupt.
or
>>The dump file was generated on Oracle 10
It is becuase of difference in versions
What exactly?

Report message to a moderator

Re: IMPORT Problem NEED HELP quickly [message #180437 is a reply to message #180435]

Mon, 03 July 2006 08:58

shiraifr
Messages: 4
Registered: July 2006

Junior Member

No, i didn't transfer the dump file.
It was generated on the server "A", and i'm trying to import this file on the same server "A" for another user, which i only created the desire table.

Report message to a moderator

Re: IMPORT Problem NEED HELP quickly [message #180441 is a reply to message #180437]

Mon, 03 July 2006 09:11

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

First, your exp/imp statements are not clear.

You are exporting TOTO's objects.

exp toto/titi FILE=kmaj.dmp LOG=kmaj.log CONSISTENT=Y DIRECT=Y OWNER=toto

But your import statement says you are importing from KMAJ user?

imp userid=system/passwd FILE=kmaj.dmp LOG=kmaj.log fromuser=kmaj touser=kmaj_restore IGNORE=Y buffer=1000000 tables=kmaj_fmaj

and please translate all the errors.

Report message to a moderator

Re: IMPORT Problem NEED HELP quickly [message #180446 is a reply to message #180441]

Mon, 03 July 2006 09:41

shiraifr
Messages: 4
Registered: July 2006

Junior Member

Sorry,
The right user is toto when i import the objects.

Report message to a moderator

Previous Topic:	Loading into multiple rows from same record from csv file
Next Topic:	Writting keyword to table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:11:30 CST 2024