!L@b52620#!    


sudo docker run -d \
  --name oracle-db \
  -p 1521:1521 \
  -e ORACLE_PASSWORD=!L@b52620# \
  gvenzl/oracle-xe



  sudo docker run -d \
  --name oracle-db \
  -p 1521:1521 \
  -e ORACLE_PASSWORD='!L@b52620#' \
  gvenzl/oracle-xe



  sudo docker exec -it oracle-db sqlplus system/!L@b52620#


-- Passer sur la base de données exploitable
ALTER SESSION SET CONTAINER = XEPDB1;

-- Créer l'utilisateur
CREATE USER safig IDENTIFIED BY "Saf!g@2620";

-- Lui donner les droits pour travailler
GRANT CONNECT, RESOURCE, DBA TO safig;


POur se connecter rapidement
sudo docker exec -it oracle-db sqlplus / as sysdba


sudo docker cp /home/oracle/SAFIG_DUMP.dmp oracle-db:/opt/oracle/admin/XE/dpdump/

sudo docker exec -u 0 -it oracle-db chown oracle:dba /opt/oracle/admin/XE/dpdump/SAFIG_DUMP.dmp

sudo docker exec -it oracle-db impdp system/'!L@b52620#'@XEPDB1 \
  DIRECTORY=DATA_PUMP_DIR \
  DUMPFILE=SAFIG_DUMP.dmp \
  REMAP_SCHEMA=ANCIEN_USER:safig \
  TABLE_EXISTS_ACTION=REPLACE



sudo docker exec -it oracle-db impdp system/'!L@b52620#'@//localhost:1521/XEPDB1 \
  DIRECTORY=DATA_PUMP_DIR \
  DUMPFILE=SAFIG_DUMP.dmp \
  REMAP_SCHEMA=NOM_SOURCE:safig \
  TABLE_EXISTS_ACTION=REPLACE  


impdp \"/ as sysdba\"@XEPDB1 DIRECTORY=DATA_PUMP_DIR DUMPFILE=SAFIG_DUMP.dmp SQLFILE=verif_schema.sql