This content has been marked as final. Show 2 replies
Will there be an error? Why don't you try it?
You seem to be on the right track, but
- Object SCHEMA2.T_H might not exist
- SCHEMA1 might not have privileges on it
- You might not have the right password in your database link
so it is impossible to say there will be no errors.
Actually this is supposed to be done in a live database, hence cannot be tested now.
Schema2 will have the table T_H in place, and Schema1 will have priveleges to create synonym for Schema2 and has got the right password for the database link