Thursday, August 26, 2021

What is vacuuming in PostgreSQL and how do I vacuum a table?

›
Under the headline "Vacuuming Basics" in the PostgreSQL documentation , you can read amongst other things: PostgreSQL's VA...
Friday, August 20, 2021

How to fetch first n rows only in PostgreSQL

›
The equivalent of oracles "fetch first n rows only" for postgreSQL is: select * from myschema.mytable limit 10; If you want to...
1 comment:
Wednesday, August 18, 2021

Solution for no ocijdbc18 in java.library.path when using sqlcl

›
sqlnet.ora: NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) NAMES.DEFAULT_DOMAIN = oric.no tnsnames.ora testdb01,testdb01.oric.no = (...
1 comment:
Monday, August 2, 2021

How to work around ORA-38323: policy conflicts with policy

›
You try to enable a tablespace-wide ADO policy: ORA-38323: policy conflicts with policy 42 If you lookup the error with oerr ora 38323,...

How to add a default ADO compression policy to a tablespace

›
Create the tablespace: CREATE BIGFILE TABLESPACE DATA1 DATAFILE '/oradata/mydb/data1.dbf' SIZE 1024M AUTOEXTEND ON NEXT 256M MA...
Wednesday, June 30, 2021

How to deal with ORA-01110 during export

›
If you receive errors like this during data pump export ORA-01187: cannot read from file because it failed verification tests ORA-01110:...
Monday, June 28, 2021

How to add an ADO compression policy to a table partition

›
ADO (Automatic Data Optimization) is one component of the Oracle 12c ILM (Information Life Cycle Management) solution. For ADO to work, ac...