export errors

[learning_bee]

I have this error on my export:

EXP-00056: ORACLE error 68 encountered

ORA-00068: invalid value 1000000 for parameter sort_area_size, must be between 131072 and 0

EXP-00056: ORACLE error 68 encountered

ORA-00068: invalid value 1000000 for parameter sort_area_size, must be between 131072 and 0

EXP-00000: Export terminated unsuccessfully





I have 6 diffrent instances running on this server and all of the other ones are running ok except this one.

any thought the problems???

[Mr.Hanky]

Where and when are you setting sort_area_size?

Are you using a parfile?
Can we see it?

MH

[learning_bee]

I don't have a parfile but it's just a simple export with the file nothing special here.

sort_area_size=524000

[Mr.Hanky]

That is wierd, I have never heard of a sort_area problem with an export. There is no such export parameter.

Can you use a parfile?
What type (full, user, table) of export is this?

[learning_bee]

I mean:

exp system/manager file=blah.dmp log=blah.log full=y

I research in Metalink and it said change the number of LOG_FILES to be compatible and I am not sure what LOG_FILES they are referrign to

[zainalj]

change you SORT_AREA_SIZE value between 131072 and 0, it shud be okay