dblink - how to create a dblink between two oracle database oracle12c/11g

[@ocptechnology]

How to create db link and use between two servers step by step

[@ocptechnology]

Try kero brother

[@Cookpe]

explain practically very good way. Thanks

[@ocptechnology]

Thanks Naveen

[@hkasifmiya4198]

Nice video

[@ocptechnology]

Thank you dear 😀

[@13eau33]

Thanks a bunch! very practical.

[@harishravi7492]

Thank you able to understand db link

[@ocptechnology]

Thanks for watching dear

[@tariqueazmi514]

Before your doing any activity
Check @role
Users can easily identify you doing which server

[@lifesaint]

I understand Oracle has CDB, if we add another database in 11g, will it be CDB or PDB (I know 11g does not support PDB, but can't be two CDB, right?)

[@ocptechnology]

It will be kind of PDB, but not actually pdb

[@talkies7074]

Great video...thank you.have one doubt you have created the acer user but you haven't connected to Acer so it is necessary to loging through it or we can use as sys login

[@ocptechnology]

You can use sys user

[@parthparth8680]

Good video, but how to link mumbai database to delhi database, what kind of setting we have to do
on DBSERVER in mumbai database & delhi Database.

[@ocptechnology]

There are two settings required at the server level
1. both servers must be ping to each other
2. tnsping must be working both sides

[@NoPasaran20584]

What if I write @myself (I mean my own database). As far as I understand it is not common practice, but it works. Am I right?

[@AP360-AP]

We will create dblink after login with user acer. Right? But it is not showing in your video. Please correct me

[@ocptechnology]

Please watch again carefully

[@svpoornima9945]

Hi Sir both the servers need to be ping for DB Link creation?

[@ocptechnology]

Yes

[@shakhawatshakil8336]

Thanks a lot brother. If possible please provide me a link for sending email by using Oracle DB 21c enterprise edition
and Oracle Apex.

[@karthikkumarreddy1044]

How to create a db link if don't know the password of the target user? and how to create a db link using procedure?

[@AhmedKamal-ps9rq]

can i make ddl statments through the DB link ?? drop - alter - create

[@EnterToLaugh]

How to give only select grant on production table

[@ocptechnology]

Brother tell me you want to grant on single table or all table?

[@ManishKumar-xi3sw]

To be very frank you may know very well but explanation is very bad. Can't Relate even with single thing. May be expert can relate but as a new in oracle did not got anything

[@ocptechnology]

Thanks for your feedback, I'll keep it in my mind