11-06-2008
Adding date to oracle exp log
I want to add a date/time stamp to the front of each line in an oracle exp log file. I created a shell script:
rm -f expTest.Pipe
mknod expTest.Pipe p
date "+%Y.%m.%d %T"
nawk -f expTest.nawk expTest.Pipe > expTest.Tlog &
exp userid=UID/PW@DB file=expTest.dmp log=expTest.log owner=OWNER 2>> expTest.Pipe
date "+%Y.%m.%d %T"
rm -f expTest.Pipe
and a nawk script (expTest.nawk):
BEGIN {
DT= "date \"+%Y.%m.%d %T\""
DT | getline cur_date
close(DT)
}
{
print cur_date, $0;
}
But when run, the date values are all the same (the start time of the script), even thought this takes about 60 seconds to complete.
Running on Solaris. I've tried awk but it repeatedly fails on the 'DT | ...' line
What am I doing wrong? Thanks in advance.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi. I'm trying to output the current date to a cronjob log file. Nothing seems to work, echo $(date), echo `date` or just date in the script. I'm using /sbin/sh
Any ideas? Thanks, John (2 Replies)
Discussion started by: JohnH
2 Replies
2. UNIX for Dummies Questions & Answers
I want to add a date to a record which is appended to a file that gets its data from an external source. An explanation:
1. Getting external data: curl http://www.example.com/temperatures.txt
2. Getting the required record: | grep mylocation
3. Appending to file: >> mytemperatures.txt
... (2 Replies)
Discussion started by: figaro
2 Replies
3. UNIX for Dummies Questions & Answers
Morning all
Im hoping you can help me. We have a nice new oracle server :( and are needing to move some files around for EDI and BACS. The server runs windows but has an app called MKS toolkit installed which give unix commands. (Needed for the oracle stuff) I have had a go using dos commands... (2 Replies)
Discussion started by: ltodd2
2 Replies
4. UNIX for Dummies Questions & Answers
Hi, I need
to make some extraction . with the following input to get the right output.
input: /etc/exp/home/bin ====> output: exp
and
input: aex1234 ===> output: ex
Thanks for your help, (4 Replies)
Discussion started by: yeclota
4 Replies
5. Programming
As a disclaimer, I am not a database person. I have some basic knowledge, but my area is in other fields. Please treat me like I am stupid when it comes to this question.
An Oracle script has been dumped on me, which I have been able to work out an understanding of, but I need to make a change... (5 Replies)
Discussion started by: Elric of Grans
5 Replies
6. Shell Programming and Scripting
:(
---------- Post updated at 01:51 AM ---------- Previous update was at 01:50 AM ----------
Not working
---------- Post updated at 02:04 AM ---------- Previous update was at 01:51 AM ----------
cp -p /home/* home/exp/*.`date`
i am using this (4 Replies)
Discussion started by: rishiraaz
4 Replies
7. Shell Programming and Scripting
Hi! I am trying to read a file and every line has a specific date as one of its fields.
I want to take that date and compare it to the date today plus 6 days.
while read line
do
date=substr($line, $datepos, 8) #date is expected to be YYYYMMDD
if ; then
...proceed commands
... (1 Reply)
Discussion started by: kokoro
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I want to add some hours and minutes to the current date. For example, if the current date is "July 16, 2012 15:20", i want to add 5 hours 30 minutes to "July 16, 2012 00:00" not to "July 16, 2012 15:20". Please help.
Thanks! (4 Replies)
Discussion started by: manojgarg
4 Replies
9. Shell Programming and Scripting
To delete log files content older than 30 days and append the lastest date log file date in the respective logs
I want to write a shell script that deletes all log files content older than 30 days and append the lastest log file date in the respective logs
This is my script
cd... (2 Replies)
Discussion started by: sreekumarhari
2 Replies
LEARN ABOUT MOJAVE
io::pipe5.18
IO::Pipe(3pm) Perl Programmers Reference Guide IO::Pipe(3pm)
NAME
IO::Pipe - supply object methods for pipes
SYNOPSIS
use IO::Pipe;
$pipe = IO::Pipe->new();
if($pid = fork()) { # Parent
$pipe->reader();
while(<$pipe>) {
...
}
}
elsif(defined $pid) { # Child
$pipe->writer();
print $pipe ...
}
or
$pipe = IO::Pipe->new();
$pipe->reader(qw(ls -l));
while(<$pipe>) {
...
}
DESCRIPTION
"IO::Pipe" provides an interface to creating pipes between processes.
CONSTRUCTOR
new ( [READER, WRITER] )
Creates an "IO::Pipe", which is a reference to a newly created symbol (see the "Symbol" package). "IO::Pipe::new" optionally takes two
arguments, which should be objects blessed into "IO::Handle", or a subclass thereof. These two objects will be used for the system call
to "pipe". If no arguments are given then method "handles" is called on the new "IO::Pipe" object.
These two handles are held in the array part of the GLOB until either "reader" or "writer" is called.
METHODS
reader ([ARGS])
The object is re-blessed into a sub-class of "IO::Handle", and becomes a handle at the reading end of the pipe. If "ARGS" are given
then "fork" is called and "ARGS" are passed to exec.
writer ([ARGS])
The object is re-blessed into a sub-class of "IO::Handle", and becomes a handle at the writing end of the pipe. If "ARGS" are given
then "fork" is called and "ARGS" are passed to exec.
handles ()
This method is called during construction by "IO::Pipe::new" on the newly created "IO::Pipe" object. It returns an array of two objects
blessed into "IO::Pipe::End", or a subclass thereof.
SEE ALSO
IO::Handle
AUTHOR
Graham Barr. Currently maintained by the Perl Porters. Please report all bugs to <perlbug@perl.org>.
COPYRIGHT
Copyright (c) 1996-8 Graham Barr <gbarr@pobox.com>. All rights reserved. This program is free software; you can redistribute it and/or
modify it under the same terms as Perl itself.
perl v5.18.2 2013-11-04 IO::Pipe(3pm)