hello dear
When using EXP to export data by user in ORACLE, some user tables will have an error of ‘EXP-00003: no storage definition found for segment...’ and the table data export fails.
The EXP-00003: no storage definition found for segment .... error appears in the EXP log table, and the data export of the table with this error fails.
The problem is caused by a bug in ORACLE, and the view exu9tne needs to be modified
Execute the following statement:
CREATE OR REPLACE VIEW exu9tne
(tsno, fileno, blockno, length)
AS SELECT ts#, segfile#, segblock#, lengthFROM sys.uet$
WHERE ext# = 1
UNION ALL
SELECT * FROM SYS.EXU9TNEB/
Then export the data through the EXP tool can be successful
Then execute
CREATE OR REPLACE VIEW exu9tne
(tsno, fileno, blockno, length)
AS SELECT ts#, segfile#, segblock#, lengthFROM sys.uet$
WHERE ext# = 1
Restore the view back.