Oracle link Sql Server, how to drop table
0
How to delete a table in oracle using linked sql server?
select 1 from openquery(oralink, 'drop table temp')
Or
Exec('drop table temp', oralink)
Error permission or does not create table.
sql-server oracle edited Nov 16 '18 at 7:03
Sami
9,20331244
asked Nov 16 '18 at 7:01
Gennady KretininGennady Kretinin
65
|
show 2 more comments
0
How to delete a table in oracle using linked sql server?
select 1 from openquery(oralink, 'drop table temp')
Or
Exec('drop table temp', oralink)
Error permission or does not create table.
sql-server oracle edited Nov 16 '18 at 7:03
Sami
9,20331244
asked Nov 16 '18 at 7:01
Gennady KretininGennady Kretinin
65
clearly issue in permission, are you able to run a simple select ? and can you check if you have permission on the table from the sql server or the user from oracle also does it have permission
– Moudiz
Nov 16 '18 at 7:39
yes, there is a connection and select is done
– Gennady Kretinin
Nov 16 '18 at 7:41
ok then check from oracleuseryou have permission to drop table, can you from oracle create a dummy table then drop it. then from sql server can you do the same ?
– Moudiz
Nov 16 '18 at 7:47
yes, in oracle client I can create and drop table. I can not run through sql server
– Gennady Kretinin
Nov 16 '18 at 7:58
why you cnnt run it through sql server?
– Moudiz
Nov 16 '18 at 8:00
|
show 2 more comments
0
0
0
How to delete a table in oracle using linked sql server?
select 1 from openquery(oralink, 'drop table temp')
Or
Exec('drop table temp', oralink)
Error permission or does not create table.
sql-server oracle edited Nov 16 '18 at 7:03
Sami
9,20331244
asked Nov 16 '18 at 7:01
Gennady KretininGennady Kretinin
65
How to delete a table in oracle using linked sql server?
select 1 from openquery(oralink, 'drop table temp')
Or
Exec('drop table temp', oralink)
Error permission or does not create table.
sql-server oracle sql-server oracle edited Nov 16 '18 at 7:03
Sami
9,20331244
asked Nov 16 '18 at 7:01
Gennady KretininGennady Kretinin
65
edited Nov 16 '18 at 7:03
Sami
9,20331244
asked Nov 16 '18 at 7:01
Gennady KretininGennady Kretinin
65
edited Nov 16 '18 at 7:03
Sami
9,20331244
edited Nov 16 '18 at 7:03
Sami
9,20331244
edited Nov 16 '18 at 7:03
Sami
9,20331244
9,20331244
asked Nov 16 '18 at 7:01
Gennady KretininGennady Kretinin
65
asked Nov 16 '18 at 7:01
Gennady KretininGennady Kretinin
65
asked Nov 16 '18 at 7:01
Gennady KretininGennady Kretinin
65
65
clearly issue in permission, are you able to run a simple select ? and can you check if you have permission on the table from the sql server or the user from oracle also does it have permission
– Moudiz
Nov 16 '18 at 7:39
yes, there is a connection and select is done
– Gennady Kretinin
Nov 16 '18 at 7:41
ok then check from oracleuseryou have permission to drop table, can you from oracle create a dummy table then drop it. then from sql server can you do the same ?
– Moudiz
Nov 16 '18 at 7:47
yes, in oracle client I can create and drop table. I can not run through sql server
– Gennady Kretinin
Nov 16 '18 at 7:58
why you cnnt run it through sql server?
– Moudiz
Nov 16 '18 at 8:00
|
show 2 more comments
clearly issue in permission, are you able to run a simple select ? and can you check if you have permission on the table from the sql server or the user from oracle also does it have permission
– Moudiz
Nov 16 '18 at 7:39
yes, there is a connection and select is done
– Gennady Kretinin
Nov 16 '18 at 7:41
ok then check from oracleuseryou have permission to drop table, can you from oracle create a dummy table then drop it. then from sql server can you do the same ?
– Moudiz
Nov 16 '18 at 7:47
yes, in oracle client I can create and drop table. I can not run through sql server
– Gennady Kretinin
Nov 16 '18 at 7:58
why you cnnt run it through sql server?
– Moudiz
Nov 16 '18 at 8:00
clearly issue in permission, are you able to run a simple select ? and can you check if you have permission on the table from the sql server or the user from oracle also does it have permission
– Moudiz
Nov 16 '18 at 7:39
clearly issue in permission, are you able to run a simple select ? and can you check if you have permission on the table from the sql server or the user from oracle also does it have permission
– Moudiz
Nov 16 '18 at 7:39
yes, there is a connection and select is done
– Gennady Kretinin
Nov 16 '18 at 7:41
yes, there is a connection and select is done
– Gennady Kretinin
Nov 16 '18 at 7:41
ok then check from oracle
user you have permission to drop table, can you from oracle create a dummy table then drop it. then from sql server can you do the same ?– Moudiz
Nov 16 '18 at 7:47
ok then check from oracle
user you have permission to drop table, can you from oracle create a dummy table then drop it. then from sql server can you do the same ?– Moudiz
Nov 16 '18 at 7:47
yes, in oracle client I can create and drop table. I can not run through sql server
– Gennady Kretinin
Nov 16 '18 at 7:58
yes, in oracle client I can create and drop table. I can not run through sql server
– Gennady Kretinin
Nov 16 '18 at 7:58
why you cnnt run it through sql server?
– Moudiz
Nov 16 '18 at 8:00
why you cnnt run it through sql server?
– Moudiz
Nov 16 '18 at 8:00
|
show 2 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53332936%2foracle-link-sql-server-how-to-drop-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53332936%2foracle-link-sql-server-how-to-drop-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
clearly issue in permission, are you able to run a simple select ? and can you check if you have permission on the table from the sql server or the user from oracle also does it have permission
– Moudiz
Nov 16 '18 at 7:39
yes, there is a connection and select is done
– Gennady Kretinin
Nov 16 '18 at 7:41
ok then check from oracle
useryou have permission to drop table, can you from oracle create a dummy table then drop it. then from sql server can you do the same ?– Moudiz
Nov 16 '18 at 7:47
yes, in oracle client I can create and drop table. I can not run through sql server
– Gennady Kretinin
Nov 16 '18 at 7:58
why you cnnt run it through sql server?
– Moudiz
Nov 16 '18 at 8:00