vim-dadbod-ui
vim-dadbod-ui copied to clipboard
Oracle Schemas ORA-00904 "COMMON" Error
Thanks for making such a good plugin.
The common column in Oracle's all_users was added in Oracle Database 12c Release 1 (12.1). In earlier versions of Oracle Database (11g and earlier), the common column does not exist in the all_users view. In my case, it does.
autoload/db_ui/schemas.vim 119 line Modify it like below.
Delete line 126 \ AND U.common = 'NO'
Delete line 137 \ WHERE U.common = 'NO'
Modify line 150 \ 'schemes_query': printf(s:oracle_args, "SELECT /*csv*/ username FROM all_users ORDER BY username"),
Hope this helps someone.