sqlFetch, table does not exist
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am trying to access a database.
myConn <-odbcDriverConnect("Driver={Oracle in OraClient11g_home1};Dbq=IIESP;Uid=user;Pwd=pass;")
table_list <- sqlTables(myConn)
res <- sqlFetch(myConn, "MV_LIFELAPSE", max = 10)
res
We find that res is a character vector of length 2.
[1] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: table or view does not existn"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM "MV_LIFELAPSE"'"
The issue I am having is that table_list contains thousands of rows. MV_LIFELAPSE is an entry in the TABLE_NAME column of table_list. I am not entirely certain of the "Driver" I am just using the code from this answer, Failure to connect to odbc database in R. It seems strange that I can view all of the available tables but am unable to retrieve results from the table.
I have accessed the data in PowerPivot using the same user and pass so I do not think it is an issue of access.
r oracle rodbc
edited Nov 26 '18 at 19:18
R Yoda
4,2832045
asked Nov 26 '18 at 18:24
sendHelpPleasesendHelpPlease
154
add a comment |
I am trying to access a database.
myConn <-odbcDriverConnect("Driver={Oracle in OraClient11g_home1};Dbq=IIESP;Uid=user;Pwd=pass;")
table_list <- sqlTables(myConn)
res <- sqlFetch(myConn, "MV_LIFELAPSE", max = 10)
res
We find that res is a character vector of length 2.
[1] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: table or view does not existn"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM "MV_LIFELAPSE"'"
The issue I am having is that table_list contains thousands of rows. MV_LIFELAPSE is an entry in the TABLE_NAME column of table_list. I am not entirely certain of the "Driver" I am just using the code from this answer, Failure to connect to odbc database in R. It seems strange that I can view all of the available tables but am unable to retrieve results from the table.
I have accessed the data in PowerPivot using the same user and pass so I do not think it is an issue of access.
r oracle rodbc
edited Nov 26 '18 at 19:18
R Yoda
4,2832045
asked Nov 26 '18 at 18:24
sendHelpPleasesendHelpPlease
154
1
Looks like your connection was opened successful but the table name is wrong (or not fully qualified). Try to add the user/schema name...
– R Yoda
Nov 26 '18 at 18:33
What would this involve? The table name is correct. I do not see a place to put arguments for schema in sqlFetch.
– sendHelpPlease
Nov 26 '18 at 18:41
1
Try to find out the schema name your table belongs to, e. g. via (select * from all_objects where object_name='MV_LIFELAPSE';). The schema name is called "owner" AFAIK. Then qualify your table name in the select, e. g.select * from schema.MV_LIFELAPSE(where "schema" is the schema name you have found out).
– R Yoda
Nov 26 '18 at 19:17
It works! Thank you.
– sendHelpPlease
Nov 26 '18 at 19:37
Great to hear that. Please drop at least a comment here what was the reason (how did you solve the problem) to help other readers. THX :-)
– R Yoda
Nov 26 '18 at 19:45
add a comment |
I am trying to access a database.
myConn <-odbcDriverConnect("Driver={Oracle in OraClient11g_home1};Dbq=IIESP;Uid=user;Pwd=pass;")
table_list <- sqlTables(myConn)
res <- sqlFetch(myConn, "MV_LIFELAPSE", max = 10)
res
We find that res is a character vector of length 2.
[1] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: table or view does not existn"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM "MV_LIFELAPSE"'"
The issue I am having is that table_list contains thousands of rows. MV_LIFELAPSE is an entry in the TABLE_NAME column of table_list. I am not entirely certain of the "Driver" I am just using the code from this answer, Failure to connect to odbc database in R. It seems strange that I can view all of the available tables but am unable to retrieve results from the table.
I have accessed the data in PowerPivot using the same user and pass so I do not think it is an issue of access.
r oracle rodbc
edited Nov 26 '18 at 19:18
R Yoda
4,2832045
asked Nov 26 '18 at 18:24
sendHelpPleasesendHelpPlease
154
I am trying to access a database.
myConn <-odbcDriverConnect("Driver={Oracle in OraClient11g_home1};Dbq=IIESP;Uid=user;Pwd=pass;")
table_list <- sqlTables(myConn)
res <- sqlFetch(myConn, "MV_LIFELAPSE", max = 10)
res
We find that res is a character vector of length 2.
[1] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: table or view does not existn"
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM "MV_LIFELAPSE"'"
The issue I am having is that table_list contains thousands of rows. MV_LIFELAPSE is an entry in the TABLE_NAME column of table_list. I am not entirely certain of the "Driver" I am just using the code from this answer, Failure to connect to odbc database in R. It seems strange that I can view all of the available tables but am unable to retrieve results from the table.
I have accessed the data in PowerPivot using the same user and pass so I do not think it is an issue of access.
r oracle rodbc
r oracle rodbc
edited Nov 26 '18 at 19:18
R Yoda
4,2832045
asked Nov 26 '18 at 18:24
sendHelpPleasesendHelpPlease
154
edited Nov 26 '18 at 19:18
R Yoda
4,2832045
asked Nov 26 '18 at 18:24
sendHelpPleasesendHelpPlease
154
edited Nov 26 '18 at 19:18
R Yoda
4,2832045
edited Nov 26 '18 at 19:18
R Yoda
4,2832045
edited Nov 26 '18 at 19:18
R Yoda
4,2832045
4,2832045
asked Nov 26 '18 at 18:24
sendHelpPleasesendHelpPlease
154
asked Nov 26 '18 at 18:24
sendHelpPleasesendHelpPlease
154
asked Nov 26 '18 at 18:24
sendHelpPleasesendHelpPlease
154
154
1
Looks like your connection was opened successful but the table name is wrong (or not fully qualified). Try to add the user/schema name...
– R Yoda
Nov 26 '18 at 18:33
What would this involve? The table name is correct. I do not see a place to put arguments for schema in sqlFetch.
– sendHelpPlease
Nov 26 '18 at 18:41
1
Try to find out the schema name your table belongs to, e. g. via (select * from all_objects where object_name='MV_LIFELAPSE';). The schema name is called "owner" AFAIK. Then qualify your table name in the select, e. g.select * from schema.MV_LIFELAPSE(where "schema" is the schema name you have found out).
– R Yoda
Nov 26 '18 at 19:17
It works! Thank you.
– sendHelpPlease
Nov 26 '18 at 19:37
Great to hear that. Please drop at least a comment here what was the reason (how did you solve the problem) to help other readers. THX :-)
– R Yoda
Nov 26 '18 at 19:45
add a comment |
1
Looks like your connection was opened successful but the table name is wrong (or not fully qualified). Try to add the user/schema name...
– R Yoda
Nov 26 '18 at 18:33
What would this involve? The table name is correct. I do not see a place to put arguments for schema in sqlFetch.
– sendHelpPlease
Nov 26 '18 at 18:41
1
Try to find out the schema name your table belongs to, e. g. via (select * from all_objects where object_name='MV_LIFELAPSE';). The schema name is called "owner" AFAIK. Then qualify your table name in the select, e. g.select * from schema.MV_LIFELAPSE(where "schema" is the schema name you have found out).
– R Yoda
Nov 26 '18 at 19:17
It works! Thank you.
– sendHelpPlease
Nov 26 '18 at 19:37
Great to hear that. Please drop at least a comment here what was the reason (how did you solve the problem) to help other readers. THX :-)
– R Yoda
Nov 26 '18 at 19:45
1
1
Looks like your connection was opened successful but the table name is wrong (or not fully qualified). Try to add the user/schema name...
– R Yoda
Nov 26 '18 at 18:33
Looks like your connection was opened successful but the table name is wrong (or not fully qualified). Try to add the user/schema name...
– R Yoda
Nov 26 '18 at 18:33
What would this involve? The table name is correct. I do not see a place to put arguments for schema in sqlFetch.
– sendHelpPlease
Nov 26 '18 at 18:41
What would this involve? The table name is correct. I do not see a place to put arguments for schema in sqlFetch.
– sendHelpPlease
Nov 26 '18 at 18:41
1
1
Try to find out the schema name your table belongs to, e. g. via (
select * from all_objects where object_name='MV_LIFELAPSE';). The schema name is called "owner" AFAIK. Then qualify your table name in the select, e. g. select * from schema.MV_LIFELAPSE (where "schema" is the schema name you have found out).– R Yoda
Nov 26 '18 at 19:17
Try to find out the schema name your table belongs to, e. g. via (
select * from all_objects where object_name='MV_LIFELAPSE';). The schema name is called "owner" AFAIK. Then qualify your table name in the select, e. g. select * from schema.MV_LIFELAPSE (where "schema" is the schema name you have found out).– R Yoda
Nov 26 '18 at 19:17
It works! Thank you.
– sendHelpPlease
Nov 26 '18 at 19:37
It works! Thank you.
– sendHelpPlease
Nov 26 '18 at 19:37
Great to hear that. Please drop at least a comment here what was the reason (how did you solve the problem) to help other readers. THX :-)
– R Yoda
Nov 26 '18 at 19:45
Great to hear that. Please drop at least a comment here what was the reason (how did you solve the problem) to help other readers. THX :-)
– R Yoda
Nov 26 '18 at 19:45
add a comment |
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
});
}
});
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%2f53486967%2fsqlfetch-table-does-not-exist%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
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.
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%2f53486967%2fsqlfetch-table-does-not-exist%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
1
Looks like your connection was opened successful but the table name is wrong (or not fully qualified). Try to add the user/schema name...
– R Yoda
Nov 26 '18 at 18:33
What would this involve? The table name is correct. I do not see a place to put arguments for schema in sqlFetch.
– sendHelpPlease
Nov 26 '18 at 18:41
1
Try to find out the schema name your table belongs to, e. g. via (
select * from all_objects where object_name='MV_LIFELAPSE';). The schema name is called "owner" AFAIK. Then qualify your table name in the select, e. g.select * from schema.MV_LIFELAPSE(where "schema" is the schema name you have found out).– R Yoda
Nov 26 '18 at 19:17
It works! Thank you.
– sendHelpPlease
Nov 26 '18 at 19:37
Great to hear that. Please drop at least a comment here what was the reason (how did you solve the problem) to help other readers. THX :-)
– R Yoda
Nov 26 '18 at 19:45