02-01-2007
{Urgent very need help} script for conn oracle and get the content
hi experts,
very need help about script how to login into oracle database and select a table and append the query into a file.
i have oracle database and have a table named omc_ip with fields like host_id(varchar2(20)),ip(varchar2(10)) and update_date(date).
i want to build a script that can connect to oracle database and query this table and put the output into a file.
nb:using oracle8i database and solaris 8 sparc
please help
Thank you so much for your attention
Best Regards,
bucci
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi to all,
Need help! For user sysoper on oracle, I want to know who and on which date/time the password has been modified? The platform is unix itself.
Thanks (2 Replies)
Discussion started by: ashvik
2 Replies
2. Shell Programming and Scripting
Hi,
I have a file whose content and format at places is as given below.
print
coloumn ....
coloumn ....
coloumn ....
skip 1 line
print
coloumn ...
skip 1 line
I need to select the following :
print
coloumn ....
coloumn ....
coloumn... (2 Replies)
Discussion started by: jisha
2 Replies
3. Shell Programming and Scripting
Hi All,
I need urgent help. Because just now i have to give this code to my client.
I have a folder name is Testing. this Testing folder contains the following 3 files.
1.txt
2.txt
2.txt
Now I want to store the first value of my folder in a variable say suppose $a.
Means i want that... (3 Replies)
Discussion started by: sunitachoudhury
3 Replies
4. Solaris
Hi all,
I wanted to know how to install oracle on solaris (b83)..
I also would like to know of a link that i can download oracle from?
please reply fast..
I need it for my exams day after tomorrow...
please reply (1 Reply)
Discussion started by: wrapster
1 Replies
5. UNIX for Advanced & Expert Users
hai ,
i want to connect to global ftp through ip address.
remote type is unix.
sometimes it is connecting some times connection timed out is coming
what is solution (1 Reply)
Discussion started by: rajan_ka1
1 Replies
6. UNIX for Dummies Questions & Answers
I am using a oracle query from unix..
flag=`sqlplus -s <<EOF
SELECT 'Y' FROM table_name
WHERE cond1 = '${table_name}'
AND DECODE('${var_a}','''NA''',own,'${var_b0}')= own
exception
when no_data_found then
dbms_output.put_line(NVL(l_owner_flag,'X'));
end;
EOF`
Its not validating the... (7 Replies)
Discussion started by: sivakumar.rj
7 Replies
7. Shell Programming and Scripting
Hi All,
I have a flat file like this on unix AIX server:
MXBOFO CSWP 5340 3794499 MXBOBIS CSWP 5340 3581124
MXBOFO CSWP 5340 3794531 MXBOBIS CSWP 5340 3583720
MXBOFO CSWP 5340 3794514 MXBOBIS CSWP 5340 3580763
MXBOFO CSWP 5340 3795578 MXBOBIS CSWP 5340 3794995
MXBOFO CSWP 5340 3710835... (3 Replies)
Discussion started by: unknown123
3 Replies
8. Red Hat
Hi Friends,
On one of my server which having direct connection to internet without firewall ..am seeing a established connection with SSH .. am not getting how ..there no login but I can see this established connection .
## have hidden original IPs with below notations for security concerns .... (0 Replies)
Discussion started by: Shirishlnx
0 Replies
9. Shell Programming and Scripting
I habe a UNIX Variablw with content as below:
WHOLE_REC_TXT="$record"
where $record contains contents of file
Sample contents of file:
topic_id|1624|AIDS-HIV||
topic_id|1625|Allergies||
topic_id|1626|Alzheimer s||
topic_id|1627|Knee Pain||
topic_id|1628|Autism||... (2 Replies)
Discussion started by: Arun Mishra
2 Replies
10. Shell Programming and Scripting
I am trying to write a shell script which takes an input file as an arguement in the terminal e.g. bash shellscriptname.sh input.txt. I would like for the file to be read line by line each time checking if the .txt file contains certain words or letters(validating the syntax). If the line being... (1 Reply)
Discussion started by: Gurdza32
1 Replies
LEARN ABOUT SUNOS
capture-schema
capture-schema(1m) Application Server Utility capture-schema(1m)
NAME
capture-schema - stores the database metadata (schema) in a file for use in mapping and execution
SYNOPSIS
capture-schema-dburl url-username name- password password-driver a_jdbc_driver [-schemaname name] [-table tablename]* [-out filename]
Stores the database metadata (schema) in a file. You can also use the Sun Java System Studio IDE to capture the database schema. Run cap-
ture-schema as the same database user that owns the tables, so that the -username and -schemaname options are given the same username.
Additionally, you can grant the database user running the capture-schema command the ANALYZE ANY TABLE privilege.
OPTIONS
-dburl JDBC URL expected by the driver for accessing a database.
-username user name for authenticating access to a database.
-password password for accessing the selected database.
-driver JDBC driver classname in your CLASSPATH.
-schemaname name of the user schema being captured. If not specified, the default will capture metadata for all tables from all
the schemas accessible to this user. Specifying this parameter is highly recommended. If more than one schema is
accessible to this user, more than one table with the same name may be captured which will cause problems.
-table name of the table; multiple table names can be specified.
-out output target; defaults to stdout. This parameter corresponds to the schema sub-element of the sun-cmp-mapping ele-
ment in the sun-cmp-mapping_1_1.dtd file.
EXAMPLES
Example 1: Using capture-schema
capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
-schemaname cantiflas -username CANTIFLAS -password enigma -driver
oracle.jdbc.driver.OracleDriver
asadmin(1M)
Sun Java System Application Server March 2004 capture-schema(1m)