I have exported a full database from Window XP (Oracle 9i) and I would like to import it to another Oracle database in Linux (Oracle 10g). The problem is both databases have the same schema, users and tables structure, but the database in Windows has less data than in one in Linux. How can I combine or add the data from the Windows database into Linux database? Each time I tried this, the IMP utility error message appeared:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "WORD" ("WORD_ID" NUMBER(*,0) NOT NULL ENABLE, "WORD" VARCHAR2"
"(200)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITI"
"AL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 "
"FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
Of course, it will fail because the table already existed. Can IMP add data into an existing table?
If you want to add data to an existing table, use the IGNORE=Y option for your import utility. With IGNORE=Y, any error on a CREATE statement will be ignored.