备份Oracle 10g的库 在Oracle 9i中还原

1.使用SYS用户登录Oracle 10g，执行如下SQL更新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 * FROM SYS.EXU9TNEB

2.在装Oracle 9I的机器上EXP操作

3.在装Oracle 9I的机器上IMP操作

4.记得给Oracle 10G把视图改回来

CREATE OR REPLACE VIEW exu9tne (

tsno, fileno, blockno, length) AS

SELECT ts#, segfile#, segblock#, length

FROM sys.uet$

WHERE ext# = 1