Oracle: Create database link to DBA tables

1076495 pts.
Tags:
DBA
Oracle
In Oracle, can I create a database link to access several DBA tables from another user? I have to backup a table (in another tablespace) but I can't access it.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Database links are used to connect different databases, not different schemas or tablespaces on the same database.

If you want to access tables or any other type of objects from a different schema, your DBA needs to grant your user account the necessary privileges to do that, and you will need to qualify the object names with the owner (or have a public synonym for those objects).

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: