oracle11g - how do i do an incremental import into a 9i database -

i need carry out append feature of impdp utility while importing 11g database dump 9i database. need able other way round importing 11g database 9i database using same append feature of impdp utility.

from find, data pump client not compatible 9i database, append feature not available me. there way can around this?

please help.

to move data between 9i , 11g database need use original export , original import utilities rather datapump.

since want move data between different versions, this section relevant:

whenever moving data between different releases of oracle database, following basic rules apply:

• the import utility , database data being imported (the target database) must same version. example, if try use import utility 9.2.0.7 import 9.2.0.8 database, may encounter errors.

• the version of export utility must equal version of either source or target database, whichever earlier.

for example, create export file import later release database, use version of export utility equals source database. conversely, create export file import earlier release database, use version of export utility equals version of target database.

so move data 9i 11g, need export 9i binaries , import 11g binaries. move data 11g 9i, need both export , import using 9i binaries; means need 9i environment has access 11g database. if on different servers you'd need either export 9i environment accessing 11g database remotely, or have 9i installation on 11g server, @ same patch level target environment.

moving data 11g 9i seems odd thing want do, given how old 9i is, , how long has been out of support.

to cover original question behaviour similar append, the import documentation:

when tables manually created before data imported, create table statement in export dump file fail because table exists. avoid failure , continue loading data table, set import parameter ignore=y. otherwise, no data loaded table because of table creation error.

imp doesn't have truncate option, data appended onto whatever there; not without ignore=y flag import fail because object exists, rather because there data in it.