Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I installed Oracle 11g on my computer. When I export data from Oracle 10g, I get the following error code. I have translated the error in parenthesis.

 EXP-00008: 遇到 ORACLE 错误 904  (encouter oracle error 904)
 ORA-00904: "POLTYP": 标识符无效   (POLTYP: is not valid )
 EXP-00000: 导出终止失败           (export fail)

Does someone know why? I believe it is ok to export from Oracle 10g using Oracle 11g client.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Unfortunately not, you cannot export from a 10g database with the 11g client. You can, though, use a dump file from a 10g database (exported with the 10g client) to import into an 11g database (with the 11g client).

Alternatively you can use the newer datapump functionality, and if you create a database link from 11g to 10g you can even transfer the data directly between them without needing to create an intermediate dump file at all.

share|improve this answer
    
i get it. thanks. i thought it can work. –  snow8261 Feb 23 '12 at 8:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.