954,561 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

How to overwrite data(tables) in oracle database using import

i want to know tht how to overwrite data(Tables) with existing tables in oracle database.
first i imported some tables using .dmp file then some table_names was in tht .dmp file.
then again i run tht import command with tht same syntax now tht showing some tables are already exist in database.

can anyone help me to fix this warning..

shapam
Newbie Poster
22 posts since Sep 2010
Reputation Points: 10
Solved Threads: 1
 

If you are using IMP command you need to use the parameter DATA_ONLY.

If you are using IMPDP command you need to use the parameter TABLE_EXISTS_ACTION.

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You