Exporting a Window XP database to Linux
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:
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.
This was first published in February 2005