 Posted 6/14/2010 11:04:20 AM
|
|
|
|
ORA-31694: master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" failed to load/unload
Iam trying to take a datapump back up of a schema 'DSS', and i get this error message..here are the details..I have about 25GB space left on that file system.
====================================
SQL> SELECT * FROM dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
----------------------------------------------------------
SYS DPUMP_DIR1 /tmp/dump_dir
SYS WORK_DIR /ade/aime_ship_10gR2_050630/oracle/work
SYS DATA_PUMP_DIR /u10/app/ORACLE/product/10.2.0.1/rdbms/log/
SYS ADMIN_DIR /ade/aime_ship_10gR2_050630/oracle/md/admin
$expdp system/password@dss DIRECTORY=DATA_PUMP_DIR dumpfile=dssdp.dmp schema=dss
Export: Release 10.2.0.1.0 - 64bit Production on Thursday, 19 April, 2007 11:02:34
Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02": system/********@dss DIRECTORY=DATA_PUMP_DIR dumpfile=dssdp.dmp schemas=dss
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 9.202 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
....
....
ORA-31694: master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" failed to load/unload
ORA-31644: unable to position to block number 1 in dump file "/u10/app/ORACLE/product/10.2.0.1/rdbms/log/dssdp.dmp"
ORA-19502: write error on file "/u10/app/ORACLE/product/10.2.0.1/rdbms/log/dssdp.dmp", blockno 892675 (blocksize=4096)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 262144
ORA-19502: write error on file "/u10/app/ORACLE/product/10.2.0.1/rdbms/log/dssdp.dmp", blockno 892483 (blocksize=4096)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 262144
|
|
|
Posted 6/14/2010 11:04:50 AM
|
|
|
|
| From the error you are getting, there is no space on the device. Free up space and then repeat the process. Please let us know if that fixed it.
|
|
|
Posted 6/14/2010 11:05:59 AM
|
|
|
|
| You may also be hitting another limit when you get the ora error ORA-31694: Check to see if file system is mounted with largefiles option.
So the expdp is hitting max file size of 4GB.
You can ask the system admin to mount all file system with largefiles options.
|
|
|
Posted 6/14/2010 11:07:37 AM
|
|
|
|
I am trying to import the schema using impdp but it throws the below error:
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
LPX-00217: invalid character 0 (U+0000
ORA-39014: One or more workers have prematurely exited. After troubleshooting, i find that the cause of the above error is because of difference in NLS_NCHAR_CHARACTERSET. The values of NLS_NCHAR_CHARACTERSET of both databases: Export database: UTF8
Import database: AL16UTF16 Well it turns out that it's not related to the characterset. I realized that during the ftp of the dmp, it was corrupted. |
|
|
Posted 6/14/2010 11:08:24 AM
|
|
|
|
I have exported 3 schemas using Oracle 11.1.7 and trying to import only one schema into Oracle 11.1.6 and it is showing the following errors.
1).create directory exddp as 'D:\expdp';
2).grant read,write on directory expdp to system;
3).grant imp_full_database to system;
impdp system/password@test directory=expdp dumpfile=mydump.dmp schemas=test1
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-02373: Error parsing insert statement for table "SYSTEM"."SYS_IMPORT_SCHEMA_01".
ORA-00904: "ORIGINAL_OBJECT_NAME": invalid identifier
Please let me know what can be done to avoid this problem.
|
|
|
Posted 6/14/2010 11:09:14 AM
|
|
|
|
The version parameter of expdp can fix this problem.
From your 11.1.7.0 version expdp command do the following, specific to your requirements:
expdp system/manager@orcl directory=export dumpfile=test.dmp logfile=test.log schemas=test1,test2,test3 version=11.1.6.0
The dumpfile created would have the version 11.1.6.0 in its header and can be easily be imported into your existing database version of 11.1.6.0 without any issues.
|
|
|
|