Auteur/autrice : Josselin Joly
-
Ora2PG script creation project
#!/bin/sh#——————————————————————————-## Script to create an ora2pg project# Author : JJY##——————————————————————————-#set -vxclearecho » « echo » Welcome in the program to create a migration project. « echo » « echo » Write the working […]
-
About JSON in RDBMS
2 links : JSONB PostgreSQL: How To Store & Index JSON Data (scalegrid.io) PostgreSQL JSON Tutorial (postgresqltutorial.com)
-
Désactiver le mode visual sur VI
J’ai remarqué un truc bien chiant sur les nouvelles VM linux : le clic droit de la souris ne peut plus coller…! pour y remédier : echo « set compatible » > […]
-
PG_BADGER
pgbadger -j 4 –outfile $HOME/rapport_complet.html -f stderr -p ‘%t:%r:%u@%d:[%p]:’ /pglog/postgresql-2021-09-10_000000.log
-
Configuration application cloud postgres
USERNAME :: postgres://<instance>/<role>/user PASSWORD ::postgres://<instance>/<role>/password URL :: jdbc:postgresql://<instance>.<domain>:<port>/<dbname>
-
[ora2pg script] Data and metadata export (multiple schemas)
#!/bin/sh#——————————————————————————-## Created by joguess the Oracle database admin, version 2022##——————————————————————————-#data exportEXPORT_TYPE= »COPY »SCHEMA= »TITI TOTO TATA »namespace= ». »for etype in $(echo $EXPORT_TYPE | tr » » « n »)do for eschema in $(echo $SCHEMA […]
-
Service HAS
Faire repartir le service HAS. Nettoyage : /grid/oracle/product/19.0/bin/crsctl stop has -f Faire repartir : /grid/oracle/product/19.0/bin/crsctl start has
-
Ora2PG now supports oracle_fdw to increase the data migration speed
source : https://www.migops.com/blog/2021/07/01/ora2pg-now-supports-oracle_fdw-to-increase-the-data-migration-speed/
-
[PostgreSQL] Voir les tables partitionnées
WITH RECURSIVE partition_info(relid, relname, relsize, relispartition, relkind)AS (SELECT oid AS relid, relname, pg_relation_size(oid) AS relsize, relispartition, relkind FROM pg_catalog.pg_class WHERE relkind = ‘p’ AND relname = ‘mof_ple_part’ — Pour une […]
