Question : What is the intended use case for virtual columns with a function-based index? The reason I ask (novice): […]
Insufficient Privileges after creating Pluggable Database
Question : I have to confess I have no idea about this pluggable database thing. I have experience in PostgresSQL, […]
Defining password complexity and its action on “grace” state USERS
Question : I have Oracle USERS linked to external applications that came to “grace” status. I tried to change the […]
Select arbitrary single value for GROUP BY: What’s the fastest option?
Question : I have a query that I use to indicate locations in a map where there are overlapping points: […]
Is it possible to grant a user the equivalence of ownership over a another users schema?
Question : Im trying to create a trainer/trainee environment in Oracle 18c XE. So far I have 4 trainee users […]
Issue Moving data from 11g to 18c
Question : I have an rman database backup from Oracle 11g XE which i am trying to import into oracle […]
Scheduled snapshots of views (without using materialized views or Oracle Golden Gate)?
Question : I have 40 views in an Oracle 18c GIS database that are used in a map in a […]
Cannot create an additional database in Oracle 18c XE
Question : Creating a new database in Oracle 18c XE throws this error, does this mean that I can only […]