11-01-2009
thanks scottn. It worked like a charm.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to compare the 2 mysql database tables. there are around 50 tables in each DB.
my idea is
in DB1
extract result select * from table1; to alog file1
in DB2
extract result select * from table1; to alog file2
now compare log file 1 file 2
pls help me out ...
thanks in advance (5 Replies)
Discussion started by: kalyankalyan
5 Replies
2. Shell Programming and Scripting
I need to extract the data from oracle table and written the below code.
But it is not working.There is some problem with the query and output is shown is No rows selected" . If I run the same query from sql developer there is my required output.
And if I run the shell script with simple sql... (7 Replies)
Discussion started by: giridhar276
7 Replies
3. Shell Programming and Scripting
hi ,
i have control-m tool where i can schedule my unix script jobs to run automatically by created them in a table..
now i want a script to generate the sheet with table names that are created in cotrol-m tool...
i dont know whether it possible or not..
thanks in advance.
hemanth saikumar (6 Replies)
Discussion started by: hemanthsaikumar
6 Replies
4. UNIX for Dummies Questions & Answers
I want to extract a table from an HTML file. the table starts with
<table class="tableinfo"
and ends with next closing table tag
</table>
how can I do this with awk/sed...
---------- Post updated at 04:34 PM ---------- Previous update was at 04:28 PM ----------
also I want to... (4 Replies)
Discussion started by: koutroul
4 Replies
5. Shell Programming and Scripting
Hi All,
I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far.
1. Table.txt ==> database extract file
2. flat.txt ==> pipe delimited after some manipulation of the original db... (5 Replies)
Discussion started by: express14
5 Replies
6. Shell Programming and Scripting
Hi Team,
I need to create a control file with a pre-defined structure for a given table name. The table is in teradata.
Ex: Table Name: TBL1
Table structure:
create multiset table tbl1, no fallback,
no before journal,
no after journal,
checksum = default,
default mergeblockratio... (7 Replies)
Discussion started by: unankix
7 Replies
7. Shell Programming and Scripting
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies
8. Shell Programming and Scripting
I need to sort out table in a file to a format below:
Input:
this is a test
example
Cat Bee Dat
1 2 3
more Example
date
data
Bet Cla Blaa Dat
A 6 T
data..
Output:
this is a test (10 Replies)
Discussion started by: aydj
10 Replies
9. Shell Programming and Scripting
I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by
modifying the script and show me how to execute it.
First Requirement:
I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
LEARN ABOUT CENTOS
acpidump
ACPIDUMP(1) General Commands Manual ACPIDUMP(1)
NAME
acpidump - dump a system's ACPI tables to an ASCII file
acpixtract - convert ASCII acpidump output to raw binary table
turbostat - gather performance statistics
SYNOPSIS
acpidump [options]
acpixtract [options] [filename]
turbostat [options] [command [arg]...]
DESCRIPTION
This manual page documents briefly the acpidump , acpixtract and turbostat commands.
turbostat reads hardware registers and gather statistics on the processor clock frequency and C-state usage. Works properly on Nehalem and
newer processors and on Linux kernel 2.6.30 and later versions.
OPTIONS
acpidump options are as follow:
-a, --addr 0x1234
look for tables at this phisical address
-t, --table DSDT
only dump table with DSDT signature
-o, --output filename
redirect output from stdout to filename
-b, --binary
dump data in binary form rather than in hex-dump format
-l, --lenght 0x456
works only with --addr, dump phisical memory region without trying to understand it's contents
-s, --skip 2
skip 2 tables of the given name and output only 3rd one
-h, --help
outputs an help message
OPTIONS
acpixtract options are as follow:
-a extract all tables, not just DSDT/SSDT
-l list table summaries, do not extract
-s<Signature>
Extract all tables named <Signature>
OPTIONS
turbostat options are as follow:
-v makes turbostat more verbose
-i <sec>
polling interval, default is 5
When given a command turbostat runs it and outputs statistics gathered while the program was running.
EXAMPLES
Dump the DSDT table to the file DSDT.aml in binary format (this can be disassembled later with iasl(1)):
acpidump -b -t DSDT -o DSDT.aml
Show the FACP table:
acpidump -t FACP > FACP.dat
acpixtract -a FACP.dat
iasl -d FACP.dat
Dump and extract all ACPI tables:
acpidump -o DSDT.dat
acpixtract -a
Parse APIC tables:
acpidump -o DSDT.dat
acpixtract -sAPIC DSDT.dat
SEE ALSO
iasl(1),
AUTHOR
acpidump was written by Alexey Starikovskiy and Len Brown.
This manual page was written by Mattia Dongili <malattia@debian.org>, for the Debian project (but may be used by others).
October 19, 2005 ACPIDUMP(1)