How to import data's into oracle having existing values?

[V MAHESH KUMAR]

Hello,

In want to import into oracle tables thru a DMP file. The existing tables in a different system has previous data and i would like to update to latest data available in the DMP file. The usernames are same and computers are alone different.

Regards,


V.Mahesh Kumar

[amitpatel66]

Can you provide more information on your requirement?
Are you looking at IMP and EXP utility.

If you are on oracle database 10g and higher, then you can use datapump EXPDP and IMPDP utility for data export and import.

Also have a look at DBMS_DATAPUMP to do the import export operations using PLSQL.

[V MAHESH KUMAR]

Hello

Mine is Oracle 8i.

Exactly what i want is, to transfer the data from my main system to my sub system in my other place. Both have same oracle version and same user id.

Please help.

[amitpatel66]

Then you can use IMP and EXP utility to transfer the database objects from one system to another.
Google for IMP and EXP utility in oracle and you will find lot of information.

[V MAHESH KUMAR]

Thanks for reply.

I used this script
EXP vmk_fy/vmk file=vmkbk.dmp

to import
i used
imp system/manager file=vmkbk.dmp fromuser=vmk_fy/vmk touser=vmkbk.dm p

But i am not successfull. Pl. help me

Rgds,


VMK

[amitpatel66]

What is the error that you are facing?