Create a logical volume of 450 Go volume group : vg_appslogical volume : lv_ora2pgmigFS : /dev/mapper/vg_apps-lv_ora2pgmigMounted on : /apps/ora2pg/migrationlvcreate -L 450G -n lv_ora2pgmig vg_apps mkfs.ext4 /dev/mapper/vg_apps-lv_ora2pgmigmkdir -p /apps/ora2pg/migrationmount /dev/mapper/vg_apps-lv_ora2pgmig /apps/ora2pg/migration
Catégorie : Ora2pg
Migration from Oracle Legacy to postgreSQL dMZR
Migration from Oracle Legacy to postgreSQL dMZR //on the ora2Pg management server : 0- prerequisite create role role_own_DB login; 1 – export schema gives the metadata // on. read more…
POST MIGRATION ajouter un booleen
# changer type en booleenalter table « <your_table> »alter column « <your_column> »set data type booleanusing case when « <your_column> » = ‘1’ then true when « <your_column> » = ‘0’ then false else nullend;. read more…
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. read more…
[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. read more…
[ora2pg] Conversion datatype
Conversion datatype useful to convert object into postgresql Oracle to PostgreSQL Migration – SQLines Tools
Assessment ora2pg
Assessment ora2pg : ora2pg -t SHOW_REPORT -c ./config/ora2pg.conf –dump_as_html –cost_unit_value 5 –estimate_cost > ./reports/report.htmlora2pg -t SHOW_TABLE -c ./config/ora2pg.conf > ./reports/tables.txtora2pg -t SHOW_COLUMN -c ./config/ora2pg.conf > ./reports/columns.txt Compare source VS target ora2pg. read more…
Tuning ora2pg
On peut gagner du temps : 1-Si on purge 2-Si on exclut les tables vides 3-Si on calcule les stats 4-Si on ajoute de la mémoire chez Oracle 5-Si on. read more…
[ora2pg] Assessment
To be able to say “Yeah, we migrate to PostgreSQL”, we have to be confident by studying the technical aspects of it. For that, we assess the feasibility of the. read more…
[PostgreSQL] Ora2pg Install
yum install oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpmyum install oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpmyum install oracle-instantclient12.2-jdbc-12.2.0.1.0-1.x86_64.rpmyum install oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpmyum -y install perl-DBIyum install gccyum install glibc-develyum install perl-ExtUtils-MakeMaker -yyum install perl-open.noarch -y export ORACLE_HOME=/usr/lib/oracle/12.2/client64export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/libtar -xvzf ora2pg-23.0.tar.gzcd ora2pg-23.0/perl Makefile.PLmake &&. read more…
[Systeme] Create a logical volume for ora2pg
Create a logical volume of 450 Go volume group : vg_appslogical volume : lv_ora2pgmigFS : /dev/mapper/vg_apps-lv_ora2pgmigMounted on : /apps/ora2pg/migrationlvcreate -L 450G -n lv_ora2pgmig vg_apps mkfs.ext4 /dev/mapper/vg_apps-lv_ora2pgmigmkdir -p /apps/ora2pg/migrationmount /dev/mapper/vg_apps-lv_ora2pgmig /apps/ora2pg/migration