Solutions to Oracle Exp-00003 problems the day before yesterday in the Guide data occurred in the Exp-00003 error, before also encountered such a problem, the solution is to the database server on the computer, the problem solved, but this is from Oracle 9.2.0.1.0 on the client (and the database server is 10.2.0.1.0), the requirement is exported with 9.2.0.1.0 export, because the exported DMP file is imported to the 9.2.0.1.0, so the method to export to this machine does not work, after finding the corresponding document problem solved, the following solution Make a note. D:\hanganbuild>exp hangyun/hangyun@hangan100 file=c:\0425.dmp tables=sys_news export:release 9.2.0.1.0- Production on Wednesday April 13:24:34 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
With the partitioning, OLAP and Data Mining options
Exported ZHS16GBK character set and Al16utf16 NCHAR character set is about to export the specified table through the regular path ...
. . Exporting Table Sys_news
EXP-00003: Storage definition for segment not found (4,99363)
The export terminated successfully, but a warning appears. There are two solutions to this situation: the one mentioned above is exported to the server on this computer, but the DMP file will be consistent with the export version on the server. The second approach is to change the view definition of the ORACLE system on the database server side: The specific view is: Exu9tne The location of the initial creation of the view is: $ORACLE _home/rdbms/admin/catexp.sql The initial definition is:CREATE OR REPLACE VIEWExu9tne
(Tsno, Fileno, blockno, length)
As
SELECTts#, segfile#, segblock#, length
From sys. uet$
WHEREext# = 1 to re-establish the view with the SYS user logging on to the database server:CREATE OR REPLACE VIEWExu9tne
(Tsno, Fileno, blockno, length)
As
SELECTts#, segfile#, segblock#, length
From sys. uet$
WHEREext# = 1
UNION all Select "Tsno", "Fileno", "Blockno", "LENGTH" from Sys.exu9tneb note is to add the above marked red statement and then try it should be OK. D:\hanganbuild>exp hangyun/hangyun@hangan100 file=c:\0425.dmp tables=sys_news export:release 9.2.0.1.0- Production on Wednesday April 13:36:31 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
With the partitioning, OLAP and Data Mining options
Exported ZHS16GBK character set and Al16utf16 NCHAR character set is about to export the specified table through the regular path ...
. . Exporting table Sys_news 4999 rows are exported
Successfully terminates the export without warning. (Note: Oracle's system view is best not easy to change, after the operation is completed, it is best to change back to the original view)