Backup Oracle Database times Oracle exp-00003 error Reason

Original source: http://www.blogjava.net/huanghuizz/archive/2006/09/07/68212.html When using the 9205 previous version of the EXP program to export a table with LOB fields to 9205 or more databases, you will encounter an error with the error message "EXP-00003: No storage definition for segment ...", which is actually an oracle bug, You can temporarily resolve the problem by changing the definition of the view "Exu9tne" in the Monitor, as follows:

Before exporting, connect to the SYS user and run the following sql:create OR REPLACE VIEW Exu9tne (
Tsno, Fileno, Blockno, length) as
SELECT ts#, segfile#, segblock#, length
From sys.uet$
WHERE ext# = 1
UNION All
SELECT * from SYS. Exu9tneb
/

After the export is complete, run the following command to restore the definition of the view, which is used for Oracle 9, 10g or please visit Metalink to determine, or to find out the definition of the original view from User_views before running the previous command, which is a good habit for DBAs. CREATE OR REPLACE VIEW Exu9tne (
Tsno, Fileno, Blockno, length) as
SELECT ts#, segfile#, segblock#, length
From sys.uet$
WHERE ext# = 1
/