Facing issue during the export of the oracle system_ system copy

[Former Member]

Dear All,

We are exporting the R3E 47 / oracle database 9.2.0.5.0. I am facing an error in the database export phase.

Dbsl Trace : Error 12535 in stmt_fetch()

Dbsl Trace: ORA-12535 occured when executing SQL statment ( parse error offset=373)

(EXP) ERROR: Dbsl ExeRead failed

rc = 99, table "ZMT054_STOCKAGE"

( SQL error 12535)

error message retunred by Dbsl

ORA-12535:TNS:operation timed out

(DB) INFO : disconnected from DB

I have changed parameter CONNECT_TIMEOUT as per note 34479 to Value 0 restarted listener services and SAP as well. After restarting the export i am facing the same error.

Kindly suggest me pls

Regards

Raj

[JPReyes · Accepted solution]

Check this it might help,

http://www.oracle-training.cc/10g_296.htm

Regards

Juan

[Former Member · Accepted solution]

Hi Juan,

Thanks for the info link. I have changed the paramater with higher value and skipped the table , then the export went fine.

Thanks again.

Raj