Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

database sync

Status
Not open for further replies.

blink25

Technical User
Joined
Mar 20, 2007
Messages
2
Location
US
Hi there,
Here goes my question.

What I need to have is to update db_dest based on db_src. I worked into it via export/import of objects into dump file. Problem goes when i import dump file into db_dest

"IMP-00015: following statement failed because the object already exists."

Yeah,no question. oracle says it so. The object in db_dest has duplicate name as of db_src so the import process fail.

my question is how do i get db_dest updated without dropping its object proir to the import? That's the only way I know but for now, I am looking into other possble way without giving much effort on how to get this done.

I'm a bit kiddie with this stuff. please help.

Kind regards,
Blink25
 
Use the import command line parameter ignore=Y


 
Alright! thanks dude.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top