-
export errors
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???
-
Where and when are you setting sort_area_size?
Are you using a parfile?
Can we see it?
MH
I remember when this place was cool.
-
I don't have a parfile but it's just a simple export with the file nothing special here.
sort_area_size=524000
-
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?
I remember when this place was cool.
-
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
-
change you SORT_AREA_SIZE value between 131072 and 0, it shud be okay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|