Monthly Archives: July 2007

Unix file tricks

Create dummy file in UNIX================== $ dd if=/dev/zero of=testfile count=252400 bs=10240This will create a 2.5GB file. This can be used to test, if the files system supports 2g+ files. Changing the existing UNIX file to 0 byte file $ cat … Continue reading

Posted in Unix OS | Tagged | Leave a comment

AIX Stopped (SIGTTIN) ERROR

Background process trying to read from controlling terminal. Mainly happens when process in BG using read command or some command need manual intervention. For example rm

Posted in Unix OS | Tagged | Leave a comment

Oracle EXPORT AND ZIP in single command

# create a named pipemknod exp.pipe p# read the pipe – output to zip file in the backgroundgzip test.exp.gz &# feed the pipeexp userid=/ file=exp.pipe feedback=1000

Posted in Unix Oracle scripting | Tagged | Leave a comment

Data Pump expdp error UDE-00008

I recently started getting this error in expdp UDE-00008: operation generated ORACLE error 31626ORA-31626: job does not existORA-39086: cannot retrieve job informationORA-06512: at “SYS.DBMS_DATAPUMP”, line 2745ORA-06512: at “SYS.DBMS_DATAPUMP”, line 3712ORA-06512: at line 1 If you try to import the file … Continue reading

Posted in Oracle Data Pump | Tagged | 7 Comments