| Alter databse link in Discoverer Admin [message #510940] |
Wed, 08 June 2011 08:02  |
aarti81
Messages: 235
Registered: December 2007
Location: USA
|
Senior Member |
|
|
Hi All
I have a business area rfprod and i the folders in it were imported by me from an oracle 10g database. Usually i right click and import from databse, when i get the box instead of the default database i used to select the database and import the folders, but now the databse has been moved to 11g and i cannot access the databse as i have to alter the database link. Can any one please help me as how to do it? Please need help.
Thanks
|
|
|
|
| Re: Alter databse link in Discoverer Admin [message #510972 is a reply to message #510940] |
Wed, 08 June 2011 12:37  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Note: I don't know Discoverer.
If a "database link" you are talking about is this, then it is created as in this example (which means that actual code, used in your database, might be different):
create database link dbl_scott --> database link name
connect to scott --> user we are connecting to
identified by tiger --> a user is identified by this password
using 'ora10'; --> remote database alias (can be found in TNSNAMES.ORA)
Now: if you migrated from 10g to 11g, database links were also moved - at least, I suppose they were. The fact is: remote "credentials" most probably didn't change, so this DBL_SCOTT database link still creates a link to user SCOTT who is identified by its password and is located at the same remote database.
If your database link doesn't work, check what happened - was it a password, perhaps? Is the database alias in TNSNAMES.ORA?
Most probably, the simplest way to make it work would be to ask your DBA to recreate a database link (drop - create). Otherwise, you should investigate what might be wrong.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
