Reprinted:
How to solve Oracle Exp-00003 Problems
The day before yesterday when the data import occurred Exp-00003 error, also encountered this problem before, then the solution is to the database server local export, the problem solved, however, this time it is exported from the Oracle 9.2.0.1.0 client (while the database server is 10.2.0.1.0). It is required to use the export of 9.2.0.1.0 because the exported DMP file needs to be imported to 9.2.0.1.0, therefore, the export method on the local machine does not work. After finding the corresponding document to solve the problem, we will record the solution below. D: \ hanganbuild> exp hangyun/hangyun @ hangan100 file = c: \ 02.16.dmp tables = sys_newsexport: Release 9.2.0.1.0-production on Wednesday 13:24:34 2007 copyright (c) 1982,200 2, 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
The zhs16gbk Character Set and al16utf16 nchar character set have been exported. The specified table will be exported through the regular path...
... Exporting table sys_news
EXP-00003: storage definitions for segments () not found
The export is successfully terminated, but a warning is displayed. There are two solutions to this problem: one is to export data to the server, but the DMP file will be consistent with the export version on the server. The second method is to change the view definition of the Oracle System on the database server. The specific view is exu9tne. The initial creation position of the view is $ ORACLE_HOME/rdbms/admin/catexp. the initial definition in SQL is as follows:
Create
Or
Replace
View Exu9tne
(Tsno, fileno, blockno, length)
As
Select TS #, segfile #, segblock #, Length
From
Sys . Uet $
Where EXT # = 1 log on to the database server as a sys user and recreate the View:
Create
Or
Replace
View Exu9tne
(Tsno, fileno, blockno, length)
As
Select TS #, segfile #, segblock #, Length
From
Sys . Uet $
Where EXT # = 1
Union all select "tsno", "fileno", "blockno", "length" from SYS. exu9tneb. Note that it is okay to add the statement marked red above and try again. D: \ hanganbuild> exp hangyun/hangyun @ hangan100 file = c: \ 02.16.dmp tables = sys_newsexport: Release 9.2.0.1.0-production on Wednesday 13:36:31 2007 copyright (c) 1982,200 2, 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
The zhs16gbk Character Set and al16utf16 nchar character set have been exported. The specified table will be exported through the regular path...
... The table sys_news row 4999 is being exported.
The export is successfully terminated without warning. (Note: it is best not to change the system view of Oracle easily. After the operation is completed, it is best to change it back to the original view)
