Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-30044: Resumable cannot be enabled with distributed transactions

755678Nov 20 2010 — edited Nov 20 2010

Hi,

I am performing an import of one schema and I am hitting this error. Please suggest me how to proceed further!

ORA-30044: Resumable cannot be enabled with distributed transactions
IMP-00000: Import terminated unsuccessfully

My database is running on 9.2.0.8.0 on HPUX RISC 64 bit platform.
I tried the below commands while performing the import. Please help!

$ cat imp.par
fromuser=ELMOV4ATG,ELMOV4APP
touser=ELMOV4ATG,ELMOV4APP
file=PROD_dynocop5_2schemas_18nov2010.dmp
log=PROD_dynocop5_2schemas_18nov2010.log
ignore=y
commit=Y

$ cat imp_01.par
file=PROD_dynocop5_2schemas_18nov2010.dmp
log=imp_PROD_dynocop5_2schemas_18nov2010.log
fromuser=ELMOV4APP,ELMOV4ATG
touser=ELMOV4APP,ELMOV4ATG
ignore=y
commit=Y
resumable=y
resumable_timeout=10800
buffer=500000000

Thanks!

Edited by: user9104898 on Nov 20, 2010 11:48 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2010

Added on Nov 20 2010

#general-database-discussions

1 comment

278 views