vim-dadbod-ui icon indicating copy to clipboard operation
vim-dadbod-ui copied to clipboard

Oracle Schemas ORA-00904 "COMMON" Error

Open ParkJaeSeong opened this issue 8 months ago • 1 comments

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.

ParkJaeSeong avatar Jun 09 '24 15:06 ParkJaeSeong