Как тебе такое, илон маск? [root@invoice-main ~]# su - oracle [oracle@invoice-main ~]$

sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 30 23:22:23 2019

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select count(*) from invoice.bas_product;

COUNT(*)
----------
3769

SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@invoice-main ~]$ sqlplus voip_dev_analytics/supadupapassword

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 30 23:23:25 2019

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Wed Jan 30 2019 13:05:42 +00:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options


SQL> select count(*) from invoice.bas_product;

COUNT(*)
----------
0

SQL>

кстати, для истории. это всё VPD виноват, поэтому надо было кинуть EXEMPT ACCESS POLICY