On Wednesday, April 18, 2012 1:43:32 PM UTC-7, Jason Hines wrote:
>
> I was encountering the following error when accessing my Downtime model:
>
> OCIError: ORA-00942: table or view does not exist: SELECT *
> FROM "DBA_TAB_COLS" WHERE ("TABLE_NAME" = 'DOWNTIMES')
> This is the result of my user not having permission to access DBA_TAB_COLS.
> DBA_TAB_COLS is a system-level table and users should use USER_TAB_COLS
> instead.
>
> Making this quick change fixed it.
>
> file: lib/sequel/adapters/oracle.rb
> line: 246
> # Default values
> defaults = begin
> metadata_dataset.from(:user_tab_cols).
>
>
> I apologize in advance for the improper submission of this fix. :)
>
I'll test this in my Oracle VM. Assuming no problems, I'll commit it. Can
any other Oracle users chime in and let me know if there are any issues I
should be aware of with this approach?
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/M_yCjyoiTFcJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
