01-28-2012
You will need to write a control file and use sqlldr or similar sql data pump method (db dependant).
Other choice is use awk / perl / shell to generate insert statements from log file, that can be run against any type of database.
What is your database ?
Last edited by Peasant; 01-28-2012 at 02:43 AM..
10 More Discussions You Might Find Interesting
1. Programming
I'm having a oracle server and i'm having a table in that.
I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input.
Please explain me the flow of process in that and also... (6 Replies)
Discussion started by: rramprasad
6 Replies
2. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies
3. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
4. Shell Programming and Scripting
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies
5. Shell Programming and Scripting
Hi All,
I need to load records from oracle table XYZ to a flat file say ABC.dat.
could any one tell me how do i do this in UNXI,
Regards
Ann (1 Reply)
Discussion started by: Haque123
1 Replies
6. Shell Programming and Scripting
Hi all,
I need to know how to copy data from a table say ABC to a flat file say XYZ.dat in unix,
Please leave ur comments and the fastest way to do so,
I need to load the table records into flat file.
Regards
Ann (4 Replies)
Discussion started by: Haque123
4 Replies
7. UNIX for Dummies Questions & Answers
Hi,
my VPS was overloaded and inaccessible for some time and i want to ask for help in which log files i need to look, or which tools to setup to monitor and find the cause of repeated hig load?
watched:
/var/log/messages
/var/log/secure
/var/log/httpd/access_log
/var/log/httpd/error_log... (1 Reply)
Discussion started by: postcd
1 Replies
8. Shell Programming and Scripting
Hi All,
I get ~1000 files everyday and the current unix script process one file at a time... like it unzips the file, loads into table . This process will repeat how many ever files were present in the directory. I was wondering can we process multiple files (like unzipping and loading X amount... (1 Reply)
Discussion started by: rajasony
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I need to load data from two files to a single table.
My requirement is that I get two files in which a few column data are manadatory.
These files are identified based on the file name.
For example, I have two files ABCFile and BCDFile. ABCFile has mandatory data in column 3 and 4... (0 Replies)
Discussion started by: reshma15193
0 Replies
10. Shell Programming and Scripting
Experts.
I have created a oracle table as below.
create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);
Daily we are receiving many XML files as below.
here is our sample xml file.
File1 : (7 Replies)
Discussion started by: vasuvv
7 Replies
LEARN ABOUT REDHAT
logdump
logdump(8) JFS utility - journal log dump logdump(8)
NAME
logdump - dump a JFS formatted device's journal log
SYNOPSIS
logdump [ -a ] device
DESCRIPTION
logdump dumps the contents of the journal log from the specified JFS formatted device into output file ./jfslog.dmp.
device is the special file name corresponding to the actual device from which the journal log will be dumped (e.g. /dev/hdb1 ).
logdump must be run as root.
OPTIONS
-a Dump the entire contents of the journal log instead of just the committed transactions since the last synch point.
EXAMPLE
Dump the entire JFS journal log from the 3rd partition of the 2nd hard disk into ./jfslog.dmp:
logdump -a /dev/hdb3
REPORTING BUGS
If you find a bug in JFS or logdump, please report it via the bug tracking system ("Report Bugs" section) of the JFS project web site:
http://oss.software.ibm.com/jfs
Please send as much pertinent information as possible, including any logdump error messages and the complete output of running fsck.jfs
with the -v option on the JFS device.
SEE ALSO
xchklog(8), xchkdmp(8), mkfs.jfs(8), fsck.jfs(8), logredo(8), xpeek(8)
AUTHORS
Barry Arndt (barndt@us.ibm.com)
William Braswell, Jr.
logdump is maintained by IBM.
See the JFS project web site for more details:
http://oss.software.ibm.com/jfs
October 10, 2001 logdump(8)