First blog and DBLink
Hi All, This is Shaon and probably my first blog will gonna be proved as a boring one. Oracle is the platform where my earning and living depend on. Actually I am playing the role of DBA in an organization. So what I did in my workplace I try to document it with any form. For this purpose I initiated my blog and here i will try to share some silly knowledge with you who loves DBA and Oracle as well. Ok lets start with something like DBLink in Oracle. PURPOSE: ------------------ CREATE A DBLINK FROM ORCL DATABASE TO CONNECT TO XLE SCHEMA IN DEVP DATABASE TO ACCESS THOSE TABLES WHICH HAS PRIVILEGES IN SOME TABLES OF DEVP DATABASE. ############################################################################################################################# PRE-REQ: --------- CREATE A USER NAMED XCLE IN DEVP DB.GRANT REQUIRED PRIVILEGE TO XCLE SO THAT USER IN ORCL CAN DIRECTLY ACCESS ON THOSE TABLES OF DEVP DB. ################################################################################