Home » SQL & PL/SQL » Client Tools » db link creation (oracle 11.2.0.2, AIX)
db link creation [message #529290] Sun, 30 October 2011 17:01 Go to next message
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 #529291 is a reply to message #529290] Sun, 30 October 2011 17:04 Go to previous messageGo to next message
BlackSwan
Messages: 26201
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/311

query DBA_DB_LINKS instead
Re: db link creation [message #529292 is a reply to message #529291] Sun, 30 October 2011 19:03 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Thanks. I had created the dblink as sys user. I dropped and re-created it. It is good now. Thanks.
Re: db link creation [message #529312 is a reply to message #529292] Mon, 31 October 2011 02:15 Go to previous message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Date format and calendar type are not changing in oracle form
Next Topic: TOAD - Query output with column headers
Goto Forum:
  


Current Time: Sat Oct 20 07:32:57 CDT 2018