Home

Export/Zip and Unzip/Import using UNIX Pipes If you are creating and using large dump (.dmp) files with Oracle’s export (exp) and import (imp) utilities, you can compress and uncompress the dump file as needed using gzip and gunzip (from GNU) or the unix compress and uncompress utilities.  One problem with this is that you will…

Data Pump Export script for Linux/Solaris Data Pump is a command-line utility for importing and exporting objects like user tables and pl/sql source code from a Oracle database. It’s new since Oracle 10g, and it’s a better alternative for the “old” exp/imp utilities. However, do not use Data Pump to replace a full physical database…

Scheduler and data pump expdb Oracle Enterprise Edition 11.2.0.2Linux x86_64 I would like to routinely export some or all of my database as part of my DR strategy. I have always used crontab to call my expdp script on a routine basis. Now I want to change that from using crontab to using Oracle Scheduler.…

 find all files in directory older than 90days syntax find -type f -mtime +30 -print example   find  -type f -mtime +90 -print delete all files in directory older than 90dayssyntaxfind -type f -mtime +30 -deleteexample : find  /u02/dump -type f -mtime +90 -delete Count files in current directory ls | wc -l Free space on linux Type…

ORA-28368: cannot auto-create wallet ORA-28368: cannot auto-create wallet ORA-28368: cannot auto-create wallet If you got this error simple create a directory named “wallet” on your $ORACLE_BASE/admin/$ORACLE_SID. SQL> alter system set encryption key identified by manager; alter system set encryption key identified by manager * ERROR at line 1: ORA-28368: cannot auto-create wallet [ora11g@dbms admin]$ mkdir…