Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-01-05 03:57 AM

Error selecting Oracle data

Hello,

I am trying to select some tables from an SQL Server, but for one of them, I get the fallowing error:

" SQL ##f - SqlState: S1000, ErrorCode: 1466, ErrorMsg: [Oracle][ODBC][Ora]ORA-01466: unable to read data - table definition has changed "

I spoke with the server administrator, but no one is changing the table while I try to load it into QlikView. I thought that this was the problem.

Other tables from the same server worked fine...

Can someone help me with an answer...

Thank you,

Silviu

548 Views
0 Likes
1 Reply
nstefaniuk
Creator III
Creator III
‎2012-01-05 04:21 AM

Oracle or Sql Server ?

For Oracle, the ORA-01446 is not an issue on the columns.

Here is a link that explain the issue. I think that it should work if you wait a little, or it's an issue that should be solved by DBA.

http://www.dba-oracle.com/t_ora_01466_unable_to_read_data_table_definition_has_changed.htm

184 Views
0 Likes