exp920

+-----------+--------------------------------------------------------------+
| EXPORT | IMPORT into: |
| from +--------+--------+--------+--------+--------+--------+--------+
| \/ | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.1 | 9.2.0 | 10.1.0 | 10.2.0 |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 5.x 1) 2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x |
| 6.x 2)| EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x |
| 7.x 3)| EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.0.3 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 |
| 8.0.4 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 |
| 8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 |
| 8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 |
| 8.1.6 | EXP815 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 |
| 8.1.7 | EXP815 | EXP816 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 9.0.1 | N/S | EXP816 | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 |
| 9.2.0 | N/S | N/S | EXP817 | EXP901 | EXP920 | EXP920 | EXP920 |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 10.1.0 4)| Not Supported | EXP817 | EXP901 | EXP920 | 4) | 4) |
| 10.2.0 4)| Not Supported | EXP817 | EXP901 | EXP920 | 4) | 4) |
+-----------+--------+--------+--------+--------+--------+--------+--------+

from metalink
where can i find EXP920???

it is called exp and is available from the oracle software installation

I understand that exp920 called exp, but in $ORACLE_HOME/bin i not found "exp920". only "exp" and "expdp".

exp920 = exp in oracle 9.2.0 thats what Devey told. This is just a compatibility matrix not name of the utiltiy.

ok thank you!:)
if i have oracle 10.2 how can i do exp to 9.2??

As the matrix shows you, use the exp in the ORACLE_HOME of the 9.2 installation.

using 9.2 client / exp ( therotically, but I never did!)

i don't have oracle 9.2.. i have 10.2 but i need export for 9.2)
i must download 9.2 client??

Definitely. You need 9.2 exp.

What is it that you need out of your 10.2 database? Are you talking about several schemas, a single schema, just a few tables, or what?

single schema

The most seamless way is probably going to be installing the 9.2 client then.

yes it work, but clob information not correctly written in a table...

example?

in clob contained xml and if this xml parsing then i get error... if by hands to put them there that all normally

that doesnt make sense, need a full example if you want any help