Auto_increment problem while export-import
Hello,
I have a problem that I googled for but couldn't get any resolution.
I have 4 databases with 2 columns and a single central database with the same 2 columns. I want to put all the data from all the 4 databases into the central database. In my tables I have auto_increment field (id). When I export the data the id field too gets exported with its values. When I try to import it in the central DB then it gives problems. My central DB's auto_increment id field clashes with the id field of my other database tables.
So, how can I perform this operation? I thought maybe there is a way to avoid auto_increment field while exporting but there is none.
Please help me since this is very urgent.
Thanks a lot in advance.
Anurag
Subject
Written By
Posted
Auto_increment problem while export-import
April 25, 2009 06:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.