Database Tuning (MOSC)

MOSC Banner

9i to 10g, Datatype checking across database links

edited Mar 4, 2009 3:41AM in Database Tuning (MOSC) 2 commentsAnswered
 Hi All,
We've recently upgraded from 9i (9.2.0.5) to 10g (10.2.0.4) and have come across some changes in the behaviour of oracle.  One of these is the implementation of datatype checking when selecting across database links.  I was hoping that if I outline what's happening then someone would be able to confirm that this is now the case (maybe even provide a link to some documentation from oracle saying that these are the changes now in place?)

In 9i, we had a cursor performing a select similar to below:
SELECT some_columns
     FROM owner.table_name@database_link
     where ts_column = '0001-01-01-00.00.00';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center