Hi,
Below is the sequence of events:
1. The constraints on tables were disabled to speed up exchange partitions
2. Exchange partitioning exercise done on desired table
3. The unusable indexes rebuilt
4. The constraints were enabled using index + novalidate option
Ever since SOA server logs are showing ORA-14300 Toplink Warning messages with no mention of any specific table and no error messages whatsoever in ALERT.LOG.
Database version 11.2.0.3
Redhat Linux 6.0 server
No errors while inserting / selecting / deleting data from the partitioned tables.
I am using Range + Interval partitioning option - numtodyinterval(1,'Month').
Anybody any thoughts ?
Would disabling and enabling the constraints with validate option work here - to get rid of the warnings ?
The null values in partitioned key columns is also said to be one of the culprits ? Is it true ?
Regards,
Rupali