Q

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

Dig deeper on Oracle Application Server

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close