Question : I have a user in charge of deploying DDL on other schemas than its own. This user can […]
Tag: oracle-19c
Select failed from V$LOGMNR_CONTENTS when called from a procedure
Question : Assuming the following user with these privileges granted: — create admin user on CDB CREATE USER c##myadmin IDENTIFIED […]
What permissions are required for complex cross-schema materialized view in Oracle?
Question : I have a complex cross-schema query that I’d like to create as a materialized view in Oracle 19c […]
Oracle allows inserting into table even after revoking quota
Question : I am studying creating users and granting roles and I have come across this scenario where I grant […]
Does trailing wildcard use index? (where column like ‘value%’)
Question : I have a query on a Varchar2 field in an Oracle table: select column from tbl where column […]