| Error while doing an expdp for a large datafile [message #341798] |
Wed, 20 August 2008 06:11  |
thunder44
Messages: 4
Registered: August 2008
|
Junior Member |
|
|
Hello,
I tried an export using expdp in oracle 10g express edition. It was working perfectly until when the db size reached 2.1 gb. I got the following error message:
---------------- Start of error message ----------------
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Starting "SERVICE_2_8"."SYS_EXPORT_SCHEMA_05": service_2_8/******** LOGFILE=3_export.log DIRECTORY=db_pump DUMPFILE=service_2_8.dmp CONTENT=all
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/usr/lib/oracle/xe/oradata/service_3_0.dbf'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6235
----- PL/SQL Call Stack -----
object line object
handle number name
0x3b3ce18c 14916 package body SYS.KUPW$WORKER
0x3b3ce18c 6300 package body SYS.KUPW$WORKER
0x3b3ce18c 9120 package body SYS.KUPW$WORKER
0x3b3ce18c 1880 package body SYS.KUPW$WORKER
0x3b3ce18c 6861 package body SYS.KUPW$WORKER
0x3b3ce18c 1262 package body SYS.KUPW$WORKER
0x3b0f9758 2 anonymous block
Job "SERVICE_2_8"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 03:04:34
---------------- End of error message ----------------
Selinux was disabled completely and I have put the permission of 0777 to the appropriate datafile.
Still, it is not working.
Can you please tell me how to solve this problem or do you have any ideas or suggestions regarding this?
[Updated on: Wed, 20 August 2008 06:15] Report message to a moderator |
|
|
|
|
|
| Re: Error while doing an expdp for a large datafile [message #341831 is a reply to message #341818] |
Wed, 20 August 2008 08:40  |
thunder44
Messages: 4
Registered: August 2008
|
Junior Member |
|
|
Hello Mohammed,
The following are the datafiles:
-rw-r----- 1 oracle dba 8.8M Aug 20 08:34 control.dbf
-rw-r----- 1 oracle dba 21M Aug 20 06:10 service_2_8.dbf
-rwxrwxrwx 1 oracle dba 2.1G Aug 20 05:13 service_3_0.dbf
-rw-r----- 1 oracle dba 571M Aug 20 08:30 sysaux.dbf
-rw-r----- 1 oracle dba 361M Aug 20 08:30 system.dbf
-rw-r----- 1 oracle dba 116M Aug 18 22:01 temp.dbf
-rw-r----- 1 oracle dba 176M Aug 20 08:30 undo.dbf
-rw-r----- 1 oracle dba 101M Aug 20 05:13 users.dbf
Total size = Between 3.4gb and 3.5gb which is less than 4gb of Express edition's limit.
I have given 0777 Linux permission (full permission) to the datafile service_3_0.dbf
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
