When trying to compare two tables error ora-12151 is displayed

Toad Data Point & Toad Intelligence Central
1

Hi all,

I have been having problems with Toad for data Analysts compare V 3.0.1.1734. The tables I am comparing have a CLOB in them. I have been having problems with other tables with the similar CLOB, but this one will not complete. It takes 1 hour and 45 minutes, shows it 100 percent complete, and then errors out. I am getting the error ora-12151. It has approximately 24k rows.

ORA-12151: TNS:received bad packet from network layer.

Please help.

Thanks,
Patrick

2

Hi Patrick!

Looks unbelievable long to compare 24k rows at first sight.
Can you please advise how big your CLOB data in each field?
Can you try to compare with limiting the compare for only 100 rows? you can apply criteria on the mapping step of new/edit compare wizard, use “where clause” at the bottom of “select columns for compare” form.
Would it be possible to send to me your DDL script and sample data? I understand it may be sensitive for your business but same time it will help us to pinpoint the problem - use my e-mail instead of posting on community: valentinbaev questcom

Looking forward for your reply.

P.S.: Just in case you don’t need this column(data) to be compared - exclude it from comparison.

3

Hi Valentine,

I have been able to run this compare without the clob column. The clob column is called “DATA” (i know very original), and is 4000 characters.

Here are the table specs:

Table name:
EIN_SAVED_ORDERS

Columns:
CUST_ACCT_ID VARCHAR2 (80)
DATE_ENTERED DATE
DATA CLOB SIZE (4000)
TEMPLATE VARCHAR2(1)
FILE_NAME VARCHAR2(8)
PAYER_CRS_ID VARCHAR2(20)

Thanks!
Patrick