Home| Progetto| Web| Faq| Acronimi | ||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Oracle...
Script:
Esempio schema per analisi sui processi e parametri del db
Unix...
Tip:
Rimuovere un file in Unix / Delete a file
PLSQL...
Script:
Gestione errori
Shell scripting...
Script:
Compact if construct
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
Php Funzione mail()
XPath is a language for addressing parts of an XML document.
It is designed to be used by XSLT and XPointer.
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
|
Shell scripting
Home >Shell scripting > Shell script automating oracle data pump schema export
Oracle 10g Data Pump utility is revolutionary. It allows write and scheduling parallel export server side quickly and handy. Sometimes, in my test environment I still use shell scripts as this one to execute export routines even with Data Pump. Sometimes, I use a slight different script that takes advantage of parallel export and compress files on backgrounds. Features:
# file expschemas.sh
# tested on SunOS 5.10 clear declare -a vschema # set the array with the name of schemas to export vschema[0]=SCOTT vschema[1]=SCHEMA1 vschema[2]=SCHEMA2 export vdpdir=replat_dump echo "INSERIRE PASSWORD x SYSTEM " read -s psw i=0 while [ "$i" -lt "${#vschema[*]}" ] do export vdumpfile=${vschema[$i]}_`date +%Y_%m_%d`.dmp export vlogfile=${vschema[$i]}_`date +%Y_%m_%d`.log echo "... EXPORT SCHEMA: ${vschema[$i]} IN FILE $vdumpfile" expdp system/$psw PARALLEL=4 dumpfile=$vdumpfile schemas=${vschema[$i]} logfile=$vlogfile directory=$vdpdir echo "... FILE COMPRESSION $vdumpfile" compress $vdumpfile vdumpfile="${vdumpfile}.Z" echo "... FILE POLICIES $vdumpfile" echo $vdumpfile chmod a=xr $vdumpfile let i+=1 done Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Script ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Comandi ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Cerca A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
Oracle...
Definizioni:
Schema and user
Shell scripting...
Script:
Compact if construct
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |