Hi Jo,

The new source character set is in Unicode.

The mappings are done with source DT_STR for source and target external columns.

Do I need to change the code to DT_WSTR...

Job was good till we changed the source objects with synonyms created by db link through other database.

what does this error signify

Expression: IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents...

Thank You for the reply Jo.

Yes, there is unicode conversion in the source database. What are the options I have now?

We do not have any plans to change the table...

I just checked the NLS_CHARACTERSET for old database(9i) is WE8ISO8859P1 and for new datatabse(11g) is AL32UTF8

Is this causing the issue?

Hi Jo,

We are not migrating. But the 11g is altogether a new database.

Yes, we have Oracle 11g client installed

Thank you

Chalmsbi

I tried running from command prompt from both 32 bit(Program Files(86) and 64 bit Program Files folders.

Job fails in both

64 bit Error -

Started: 1:02:54 PM

Progress: 2012-08-14 13:02:58.03

...

Old and New database table structure is same.

Client is Oracle 11g.

No derived columns.

But there are CLOB columns.

Hi, Could someone tell me how to resolve this issue.

I changed my oracle source database from 9i to 11g.

Everything worked fine earlier.

But I get the following error now

Code: 0xC02020F6...

Oracle 10.2 client installed on the server.

I am able to connect to the database directly from the server but the package is not able to connect to the new source....

Hi, Can anyone share your thoughts.