Oracle DBA by Example. Code samples, Scripts, Reference.
Pages
(Move to ...)
Home
▼
Tuesday, April 25, 2017
bash example. expdp and scp of generated dmp file
›
================================== General ================================== Example of running oracle expdp, amd scp of generated dmp f...
Sunday, March 26, 2017
Code Example reprocess_one_file_main.bat: batch calling sqlplus, perl, bash and scp.
›
=============================== General =============================== There is a following flow: main batch is calling several other b...
Wednesday, March 15, 2017
Tablespace Fast Reference
›
==================== Get Tablespace Usage ==================== SET LINESIZE 120 SET PAGESIZE 200 SPOOL tablespace.txt SELECT TABLES...
vi editor
›
vi Reference vi Short reference.pdf vi Editing commands vi command description i insert at the current position I insert at the be...
Wednesday, March 1, 2017
Correct Corrupted Undo Tablespace Segment
›
===================== Issue ===================== Due to a power failure Oracle server was abruptly shutdown. After Linux server was sta...
‹
›
Home
View web version