Friday, September 30, 2022

What exactly is the LOCAL_LISTENER parameter, and what does it do?

›
What is the local_listener parameter? It is a parameter that points to the listener running on the local server. What is the purpose of t...
Wednesday, September 28, 2022

How to use the html markup option in sqlplus

›
Use the following directives in sqlplus: set timing on set trimspool on set markup html on spool on head MYHEADLINEHERE table "width=...
Tuesday, September 27, 2022

What is the difference between dba_services and v$services?

›
Why do we see differences in output between dba_services and v$services view ? SQL>select name from v$services; NAME ----------------...
Thursday, September 15, 2022

What is the catcon.pl script used in a Multitenant Database installation?

›
What is the catcton.pl script? From Doc ID 1932340.1: Oracle has provided script catcon.pl to execute scripts at Container and Pluggable...
Thursday, September 1, 2022

What is the missing privilege when receiving ORA-01031: insufficient privileges when switching container?

›
You need to grant the SET CONTAINER system privilege to a common user, in order for the user to be able to switch container. Eksample: yo...
Wednesday, August 31, 2022

Rename table in postgreSQL: syntax

›
Rename a table: alter table myschema.mytable rename to mytable_old; Change ownership for a table: alter table myschema.mytable owner to ...
Friday, August 26, 2022

How to generate insert statements for a table in PostgreSQL

›
Thanks to Carlos Becker for pointing out the following solution on how to generate insert statments for a table in PostgreSQL pg_dump myd...