Thursday, June 17, 2021

How to list partitions and their LOB segment sizes

›
SELECT ts.table_owner "owner", ts.table_name "table name", s.SEGMENT_NAME "segment name", ...

How to generate dbms_application_info settings together with DDL in a sql script

›
Many DBAs forget to incoporate usage of dbms_application_info into their own scipts. This is particulary important if you start long-runni...
Thursday, June 10, 2021

How to extract all mountpoints for oracle data files in a database

›
To extract all unique mount points used for datafiles in a database, used the query below: SELECT distinct SUBSTR(FILE_NAME, 1, ...
Tuesday, June 8, 2021

Workaround for ORA-39358 during import

›
When running import, you may sometimes run into the problem below: impdp parfile=myparfile.par Import: Release 12.2.0.1.0 - Production on...
Thursday, May 27, 2021

How to fix error message from data guard broker "Property 'DbFileNameConvert' has inconsistent values"

›
After a rebuild of a physical standby database, I was tailing the broker log file drcSALES.log, and noticed the following warning: Proper...

Is default partition supported for partitioned tables in PostgreSQL?

›
Yes it is! From version 11, it is possible to create a default partition for partitioned tables in PostgreSQL. See the documentation fo...
Wednesday, May 26, 2021

How to trim output from a psql file - equivalent to SET commands in sqlplus

›
I have the following query, which will generate DML: SELECT 'drop table ' || table_schema || '.' || table_name ||';...