Oracle

${ORACLE_HOME}/bin/sqlplus -s user1/pass1 <<EOF
select * from TABLE1;
delete from TABLE1;
quit
EOF
 
echo "select * from TABLE1;" | ${ORACLE_HOME}/bin/sqlplus user1/pass1

select table_name from all_tables;

su oracle -
 
$ crontab -l
MAILTO=foo@example.com
ORACLE_HOME=/oracle/app/product/11.2.0/dbhome_1
 
0 20 * * 0-5 ${ORACLE_HOME}/bin/expdp system/PASSWORD@INSTANCE full=y directory=backup compression=all dumpfile=INSTANCE.full.$(date -I).dmp logfile=INSTANCE.full.$(date -I).log
0 21 * * * find /oracle/backup -mtime +3 -name "INSTANCE.full.*" -exec rm {} \;

${ORACLE_HOME}/bin/expdp USER/PASS schemas=SCHEMA_NAME directory=backup dumpfile=INSTANCE.full.$(date -I).dmp logfile=INSTANCE.full.$(date -I).log 

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_SID=XE
${ORACLE_HOME}/bin/imp user1/pass1 FROMUSER=user2 TOUSER=user3 TABLES=table1,table2 file=${FILE} log=/tmp/imp.log
 
# schemas=schema1,schema2
# remap_schema=schema1:schema2
# remap_tablespace=user1:user2
# full=yes
 
/oracle/app/product/11.2.0/dbhome_1/bin/impdp user1/pass1 TABLES=table1,table2 TABLE_EXISTS_ACTION=REPLACE DUMPFILE=BACKUP:db1.full.dmp LOGFILE=BACKUP:imp.$(date -I).log

docker run -d -p 49160:22 -p 49161:1521 -v /storage/dpdump:/u01/app/oracle/admin/XE/dpdump wnameless/oracle-xe-11g
sshpass -p admin ssh root@localhost -p 49160
 
docker stop $(docker ps -q --filter ancestor=wnameless/oracle-xe-11g)

# tns listener
netstat -tulpen | grep 1521
lsnrctl start