if you put those details in environment variable then -
ex. suppose you have 15 records including 2 headers and 2 footers.
so total load comes 15 - 2 - 2 = 11
In control file you have declared SKIP=2, that means it will skip those headers. Now it will load only 11 record starting from 3rd record and will leave your last 2 records because it can load only 11 records. And those last 2 records are footers.
Hi guys, my supervisor has asked me to solve the problem in 7 days, I've taken 3 days to think about it but couldn't figure out any idea.
Please give me some thoughts with the following problem,
I have index.database that has only index date:
1994
1995
1996
1997
1998
1999
I have... (6 Replies)
When i try to run a job in unix, i am getting
sqlload error as,
sqlload : file not found.
Can any one please let me know whats the reason for this..
The PATH & ORACLE_HOME paths names are correct...
thanks:confused:
hr is the script:
here is the script : plz hv a look
TABLE_NAME=... (2 Replies)
Hi
My question might sound crazy, but nevertheless, I have made mu mind to ask. Please ignore if I sound absurd.
I have a shell script. When run, this script, prints out a menu to the user and takes the input from the user. It works fine. I just wondered, is it possible to have a 'footer'... (2 Replies)
Hi All,
I am trying to load a data from a files in a particular directory to a database..
cd $SCC
isql metdb >> ${LOGDATA}/LOAD.LOG < !
load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE
!
But it's showing the error "syntax error at line 46 : `<<' unmatched"
Can u plz help me... (5 Replies)
Hi,
I have two files:
first input file is having 7-8 columns,
and second data file is like
I want to arrange my datafile1 in the order given in second data file, by comparing the seconddatafile with the second column of first file and print the entire line....also if any... (2 Replies)
I have two files which are getting sent to a UNIX server in order to be bcp'd into a database. The bcp is failing because there's a header and footer row on the file which give the date of the file and the number of rows in it. That's because the file is also being used for another process, so we... (1 Reply)
This is my file(Target.txt)
name|age|locaction
abc|23|del
xyz|24|mum
jkl|25|kol
The file should be like this
1|03252012
1|name|age|location
2|abc|23|del
2|xyz|24|mum
2|jkl|25|kol
2|kkk|26|hyd
3|4
Column 1 is row indicator
for row 1 and 2, column indicator is 1,for data rows... (1 Reply)
Hi Every one,
what is the coomand to remove header or footer from a file.
Please help me by providing command/syntax to remove header/footer from unix.
Thanks in advance for all your support. (5 Replies)
Hi,
I have the following requirement:
I have load_cdr as main scriptwhich loads all the file records into vertica database through unix script. But there are two files which try to update same table..n thats y my script is getting failed...
Can any1 give me some logic how to over come this... (6 Replies)
Hi all,
Could anyone please share ideas or logic on how to automate add/resize datafile in Oracle ASM Storage for Oracle RAC/Single Node databases when any tablespace space alert is trigerred by OEM?
Thanks for your help and time on it!
Thanks®ards,
a1_win
Please DON'T use CODE tags... (0 Replies)
Discussion started by: a1_win
0 Replies
LEARN ABOUT DEBIAN
xmark
Xmark(1) General Commands Manual Xmark(1)NAME
Xmark - summarize x11perf results
SYNTAX
Xmark datafile
DESCRIPTION
Xmark is a shell script that reads the indicated datafile and compiles a benchmark which it writes to standard output. It writes three
numbers:
A weighted performance number for the x11perf results.
A weighted performance number for a standard SparcStation 1, with SunOS 4.1.2, X11R5 Xsun, and a CG3 dumb Color Frame Buffer.
The Xmark, which is the ratio of the two numbers above.
The datafile must be an ordinary file, produced by x11perf in the following way:
x11perf -display display -v1.3 -rop GXcopy GXxor -all > datafile
It is possible to run the GXcopy and GXxor tests separately, as long as they are concatenated to the same output file:
x11perf -display display -v1.3 -rop GXcopy -all > datafile
x11perf -display display -v1.3 -rop GXxor -all >> datafile
or
x11perf -display display -v1.3 -rop GXxor -all > datafile
x11perf -display display -v1.3 -rop GXcopy -all >> datafile
FILES
temp.$$
Temporary file created in the current directory, deleted after use.
DIAGNOSTICS
Usage: Xmark datafile
Xmark was invoked without arguments or with more than one argument, or with options. Xmark takes no options.
Error: data file does not exist or is not ordinary.
Xmark cannot find the datafile named on its command line, or the datafile is a special file such as a directory.
WARNING: datafile contains nnn, not 441 or 447 'trep' results;
The file named on the command line does not seem to be a file generated by x11perf in the expected way.
Diagnostic: ERROR: sum of weights =nnn, not equal to 4566.0;
There is an internal error in Xmark.
SEE ALSO X(7), x11perf(1), x11perfcomp(1)X Version 11 x11perf 1.5.4 Xmark(1)