With 11G some new features and some releated changes came in picture.
Password is case sensitive in 11g, and so is needed for all the db links.
So for creating a db link b/w 10g to 11g, keep in mind to plece the password in double quotes.
Like:
SQL> create database link 10g_to_11g
connect to apps
identified by "appspass"
using 'DBIdentifier';
Quotes are not needed for db link b/w 11g to 11g.
Note:- DB link is not possible b/w release 8i or lower and 11g.
As a workaround we can have some middle release db and create some dummy user with synonyms of required objects there, with a db link.
And this can be accessed by other compatible releases of db, with again a db link.
Password is case sensitive in 11g, and so is needed for all the db links.
So for creating a db link b/w 10g to 11g, keep in mind to plece the password in double quotes.
Like:
SQL> create database link 10g_to_11g
connect to apps
identified by "appspass"
using 'DBIdentifier';
Quotes are not needed for db link b/w 11g to 11g.
Note:- DB link is not possible b/w release 8i or lower and 11g.
As a workaround we can have some middle release db and create some dummy user with synonyms of required objects there, with a db link.
And this can be accessed by other compatible releases of db, with again a db link.
Hi,
ReplyDeletebut whether this approach is recommended by oracle of having middle release db between 8i and 11g.
Regards,
Nitin