Monday, October 31, 2022

How to clear resolved errors from PDB_PLUG_IN_VIOLATIONS

›
The query below shows 4 resolved messages in the view PDB_PLUG_IN_VIOLATIONS: SELECT NAME,CAUSE,TYPE,MESSAGE,STATUS FROM PDB_PLUG_IN_VIOL...
Friday, October 21, 2022

Rename schema in PostgreSQL: syntax

›
\connect db01 alter schema schema1 rename to schema1_old; Documented here

Rename database in PostgreSQL: syntax

›
alter database db01 rename to db01; Documented here See this post for how to create a new database in PostgreSQL
Wednesday, October 19, 2022

How to prevent a user from login into a postgres database

›
alter role scott with nologin; ALTER ROLE Remember that in postgres, "users" and "roles" are used interchangably, so...
Tuesday, October 11, 2022

How to solve "Service name or network name of ... in the PDB is invalid or conflicts with an existing service name or network name in the CDB."

›
From the alert log during startup of the container database called "cdb": pdb1(3):**********************************************...

How do I make sure that services are automatically brought online in an Oracle 19c Pluggable Database?

›
In an Oracle 19c pluggable database, the service_names parameter has no bearing on whether or not the services are brought up automatically...

How to check the code level currently in use in an EBS database

›
To find the E-Business Suite and AD/TXK patch levels, log into the EBS container and use the following two queries: col abbreviation forma...