Thanks for the question, Jhonattan.
Asked: October 18, 2016 - 4:56 pm UTC
Last updated: October 19, 2016 - 1:14 am UTC
Version: 11g R2
Viewed 1000+ times
You Asked
Nice day i'm from peru so my english is not the best.
The database is a:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE 11.2.0.3.0 Production"
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
My doubt is about the dblink. If it is justifiable to create a dblink to read data from a local table ( another user table ) instead of giving grants for select. Also we have a Local Network so all request for local ips dont need to pass to the Internet Service Provider.
Maybe you think how we come with this idea. Well sometimes we do a export of a user tables and objects to another database also we changed the name of the user ( "USERPROD" to "USERTEST" ) and sometimes we got problems with the grants ( SELECT , UPDATE ... ) because we forgot to execute a manual script for grants so we try to prevent select grants issues using the DBLink.
Good day and sorry for the grammar problems.
and Connor said...
Your english is much better than my spanish !
Dont use database links for this purpose. Things get complicated with database links, because the optimizer works differently, transactions work differently.
When you do your export/import, look at the REMAP_SCHEMA parameter to take care of the name changes.
Hope this helps.
Is this answer out of date? If it is, please let us know via a Comment