[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

create dataabse link in someone else's schema

Hi guys,
There is any way to create dataabse link in someone else's schema
0
nirvairghuman
Asked:
nirvairghuman
  • 3
2 Solutions
 
slightwv (䄆 Netminder) Commented:
On mobile and cannot try it but try adding the schema:

Create database link other_schema.link_name ...
0
 
slightwv (䄆 Netminder) Commented:
Sorry but now that I am where I can look into it, you cannot:

http://download.oracle.com/docs/cd/E11882_01/server.112/e26088/statements_5005.htm#SQLRF01205

Restriction on Creating Database Links You cannot create a database link in another user's schema, and you cannot qualify dblink with the name of a schema.
0
 
icenickCommented:
0
 
slightwv (䄆 Netminder) Commented:
icenick,

Two things wrong with that post:
1: That is MySQL not Oracle.
2: It is the syntax for 'create view', not 'create database link'.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now