Hi:
First, this is not a homework problem. I just need enough of a hint to get this going...
My datafile (dataf.in) is made up of 10 sections. Each section begins with & and with &&
So it looks like this:-------------------------------------
§ion1
...etc...
&&
§ion2
...etc...... (4 Replies)
Hi ,,,,
I have move an oracle db from old server to a new server ( solaris 5.9 is the operating system ) my problem is that to new server the datafile ( *.dbf ) are in a different path .....
example
old : /export/home/data/blobs ...........
new /oracle/data/blobs.......
how i can... (3 Replies)
Hi dear friends,
Im writing a shell script which has to select the strings based on the position.
but the problem is there is no field seperator.
Normally a datafile contains 2000 records (lines) and each line is of size 500 charecters.
I want to select the fields from all the lines which... (10 Replies)
I am working on an shell script which checks for all the file starting with abc*.*
and if file found then the filelines need to append the file name in begining
can some one help with the filename appending...
for i in `ls $filename*.csv`
do
echo $i
--- NEED to append file name befor... (3 Replies)
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)
hello.
I'm somewhat a novice here so please be patient. My stumbling block when loading csvs into ORACLE tables is this:
I need to read a csv datafile, check several fields in each line, and if any of stated fields contain A ZERO only then replace it with a null/blank character.
I had a... (9 Replies)
Hi,
Is there any way we can find out which process is creating a partucular datafile.I know the user and group but i am just curios to know is there any way to find the process.
Thanks (7 Replies)
Hello,
I've tried searching the forum for an answer to my question, but without any luck...
I have a datafile looking simplified as follows:
01 02 03 04 05 06
07 08 09 10 11 12
13 14 15 16 17 18
19 20 21 22 23 24
I want to reverse it by rearranging all the numbers from last to... (16 Replies)
I am new to shell scripting and need some help. I googled, but couldn't find a similar scenario.
Basically, I need to rename a datafile. This is the scenario -
I have a file, readonly.txt that has 2 columns - file# and name.
I have another file,missing_files.txt that has id and name. Both the... (3 Replies)
Hi all,
Let say I have 2 files, 1 is source file and another is destination file.
Source file contains the following :
Kitten
Dogs
Donkey
Chicken
Turkey
And destination file contains :
Kitten, 0
Dogs, 0
Donkey, 0
Chicken, 0
Turkey, 0
Kitten, 0
Dogs, 0
Donkey, 0 (16 Replies)
Hi all,
I have this source file source.txt :
hdrEthernetSwitch1IPAddress 112.13.9.34
hdrEthernetSwitch2IPAddress 112.13.8.245
noOfRevASLAvailable 8000
noOfRevASLInUse 122
maxDOSPayload 7777
pcmdEvdoRUM Enabled
pcmdEvdoFlow Enabled
And I have this datafile to be modified :
... (5 Replies)
hi all
i have a datafile consists of fields seperated by colons. the fields are as follows : a) First and last name
b) Phone number
c) Address
d) Birth date
e) Salary
now i want to write a script naming lookup.sh using vi editor which... (4 Replies)
I have a datafile containing data in the following format
name1,employee_number1,cell1,home1,fax1
name2,employee_number2,cell2,home2,fax2
name3,employee_number3,cell3,home3,fax3
name4,employee_number4,cell4,home4,fax4
name5,employee_number5,cell5,home5,fax5
...
...
....
I would like... (6 Replies)
Hi,
Can you please tell me the Unix shell script for removing footer from the datafile while loading into external table using sqlloader
we will be skipping the header like this while creating the table
organization external
(
type oracle_loader
default directory directoryname... (5 Replies)
I have two input files 1)datafile 2)metadata file.
I have a metadata file like:
field1datatypeformat1number2string3dateyy-mm-dd
I have a data file like:
1234abc12-8-16 xyz234512-9-163456acd14-08-12
In the first row there is no correction as everything is inline with the metadata.... (3 Replies)