Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: