how to delete processing rule from DB

, ,
1

Hi,

How to delete processing rule from Data Base, when i tried to delete it am getting the following error message.

The following error has occurred:
ORA-01406: fetched column value was truncated

Regards,
jag

2

Hi Jag,

I think you can’t delete processing rule from database, because it has refernal keys to other table. Only way to use Cascade delete unless you have set the property when creating table or Alter table.
Just disable the processing rule or you can Archive the old records.

Thanks,
Sree

3

we can delete the Hub profile like this

Login in to TN DB

Delete records from tables

Partner Id, Address , Destination , PartnerBinary, Remote and Partner Tables based on the column relationship that each and every table has ( for example : partnerid, remoteid….etc)


Regards,
Jags

4

Jags,

You can delete the processing rule via TN Console, which should be sufficient and is safer than deleting from the tables. Why do you need to access TN DB?

Regards,
Mary

5

Mary,

The info given i my previous reply is to delete the HUB profile not processing rule.

I am sorry, by mistake I given reply in this.

Regards,
Jags