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 Chris Miller 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
Mar 20, 2007
2
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top