Monday, March 2, 2009

ORACLE guys just love to torture us

The Boss sent me 6 ORACLE dump files. He asked me to import them into the database at our office. I know nothing about importing dump files. I never worked with them.

So I opened the import utility. Entered my Username and password. I expected something like this. Give me the file you need to import and ORACLE will import it.

This is what I get

Import file: EXPDAT.DMP >

So I typed in the first file. (It seems that the text after the colon : is the default value.) Then pressed enter. I got this

Enter insert buffer size (minimum is 4096): 10240 >

What the!? I didn't know what buffer to put, so I just pressed enter, then I got.

List contents of import file only (Y/N): N >

Well.. enter

Ignore create errors due to object existence (Y/N): N >

Ok ignore, please import.. I beg you. Enter.

Import grants (Y/N): Y >

For God sake, Enter.

Import table data (Y/N): Y >

For the love of God. Enter

Import entire export file (Y/N): Y >

What kind of question is that? of course I need the entire file I definitely don't want the half of it . Enter.


I just specified my Username up there, but OK I will type it again, Enter!

Enter table names. Null list means all tables for user Enter table name or . if done:

Well here is the thing I don't know what's inside that file how can I enter the table names
? Enter!

Yes! I am done! thanks God.

Why don't they make these questions as parameters and save us time.
Just because ORACLE is for DBAs doesn't mean that they have to slam us every possible option and make it that complicated.

People will say yes there are a lot of options in ORACLE its not that easy. But that also doesn't mean that they have to give us every single option. We will search for it when we need it. Hollywood remember? Don't call us, we'll call you? (That's also a very great OO strategy I'll post something about it later)

For those guys who end up in this page from google looking for the import command here is a much simpler why to do it with one line.

imp system/pass@servicenet file=C:\dumps\thedump.dmp fromuser=owner touser=owner

But, (there is always a but) you have to drop all your tables that have the same name first (thanks Yaseen), I don't know if there is an option to do that. But what I know is this. A job which need 5 minutes, I took an hour to do it.

Perhaps you will notice that ORACLE is developed by left brained programmers as I mentioned here.