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 ||';...
Friday, May 21, 2021

Workaround for ORA-14634 during an attempt to split a partition containing subpartitions

›
Short background: I had a LIST/RANGE partitioned tables that needed a new partition. The table is partitioned BY LIST on column STREAM, a...
Tuesday, May 18, 2021

How to find the opening and closing time for the maintenance windows in an Oracle database

›
To see the last 7 days of opening/closing time for the maintenance windows, use this query: SELECT window_name,to_char(start_time,'dd...
Wednesday, May 12, 2021

Simple script for finding a leftover FK constraint to an interim table after a redefinisjon

›
After a redefinition of a table, you may be stuck with some FK constraints from other tables, to the old interim tables. This simple scri...

How to repeat a command for all the lines i a text file using vi

›
This is a handy command for all those using the vi editor to fix scripts with many lines. For example, I had to create statements like ...