| db link creation [message #529290] |
Sun, 30 October 2011 17:01  |
lg123
Messages: 225
Registered: August 2008
|
Senior Member |
|
|
I manually created a db link from 10g to 11g. When I query in the Sql prompt like this,
SELECT NAME,HOST,USERID,PASSWORD FROM SYS.LINK$;
I get the exact same output in both 10g and 11g databases.
But If I check in dbartisan, it shows dblink in 10g but not in 11g. I don't know the reason why it doesn't show up in dbartisan. So I get doubt whether I have properly re-created the dblink in oracle 11g from oracle 10g?
|
|
|
|
|
|
|
|
| Re: db link creation [message #529312 is a reply to message #529292] |
Mon, 31 October 2011 02:15  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:I had created the dblink as sys user
- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.
NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
