Parameter on bash.

MacBook-de-Andre-Silva als$ cat tmp.sh
#!/bin/bash

echo spool  /home/analyze_$2.log
MacBook-de-Andre-Silva als$ ./tmp.sh - info_parameter
spool /home/analyze_info_parameter.log
MacBook-de-Andre-Silva als$ ./tmp.sh - info_number
spool /home/analyze_info_number.log
MacBook-de-Andre-Silva als$

Read More

Script Rename File / Windows / Expdp

@echo off
Rem Get Day,Mth & Year from %Date%
set Day=%Date:~0,2%
set Mth=%Date:~3,2%
set Yr=%Date:~6,4%
ren 1.txt 1_%Day%-%Mth%-%Yr%_I.txt

@echo off
ren texte.txt texte_%Date:~0,2%%Date:~3,2%%Date:~6,4%.txt


set ORACLE_SID=TEST

C:\oracle\app\Administrador\product\11.2.0\dbhome_1\BIN\expdp.exe siltech/siltech@INSTANCE parfile=F:\Oracle\Backup\expdp.par

rename F:\export\expfull_TEST.log expfull_TEST_%Date:~0,2%%Date:~3,2%%Date:~6,4%.log
       
rename F:\export\EXPFULL_TEST.dmp expfull_TEST_%Date:~0,2%%Date:~3,2%%Date:~6,4%.dmp
       
forfiles -p "F:\export\" -d -5 -m *.dmp -c "cmd /c del /f /q @path"

Read More