06-17-2008
How to access Oracle table using sqlplus
Hi,
I want to use sqlplus from server1
sqlplus usr1/pass1@dns1
and I want to connect to an Oracle database from a server2.
Unfortunately the database was created on the server1 and on server2.
So when I use the command just like that...it connects to the database from the server2.
Is there a way to connect to the database found on the server2?
thank you in advance for your answers
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
2. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
3. Shell Programming and Scripting
I have korn shell scripts.
I want to pass a variable to a script which will execute a a sql script to read a table that contains env. variables. I want to read and then somehow export at unix level variables
example
for every row selected from the table build export command line
field1... (5 Replies)
Discussion started by: TimHortons
5 Replies
4. Shell Programming and Scripting
a job extracts orcle data into unix as flat file.
a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records.
(its not single record in two line. but its single record into record. ie., \n come into picture)
can you tell me what... (6 Replies)
Discussion started by: Gopal_Engg
6 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies
6. Shell Programming and Scripting
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies
7. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
8. UNIX and Linux Applications
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies
9. Shell Programming and Scripting
I want to truncate a table using sqlplus where the table name is in shell variable:
I am using :
sqlplus -s / <<end
truncate table $TABLE
end (2 Replies)
Discussion started by: IB_88
2 Replies
LEARN ABOUT CENTOS
gentest
GENTEST(1) Test Suite GENTEST(1)
NAME
gentest - Run random generic SMB operations against two SMB servers and show the differences in behavior
SYNOPSIS
gentest {//server1/share1} {//server2/share2} {-U user%pass} {-U user%pass} [-s seed] [-o numops] [-a] [-A] [-i FILE] [-O] [-S FILE] [-L]
[-F] [-C] [-X]
DESCRIPTION
gentest is a utility for detecting differences in behaviour between SMB servers. It will run a random set of generic operations against
//server1/share1 and then the same random set against //server2/share2 and display the differences in the responses it gets.
This utility is used by the Samba team to find differences in behaviour between Samba and Windows servers.
OPTIONS
-U user%pass
Specify the user and password to use when logging on on the shares. This parameter is mandatory and has to be specified twice.
-s seed
Seed the random number generator with the specified value.
-o numops
Set the number of operations to perform.
-a
Print the operations that are performed.
-A
Backtrack to find minimal number of operations required to make the response to a certain call differ.
-i FILE
Specify a file containing the names of fields that have to be ignored (such as time fields). See below for a description of the file
format.
-O
Enable oplocks.
-S FILE
Set preset seeds file. The default is gentest_seeds.dat.
-L
Use preset seeds
-F
Fast reconnect (just close files)
-C
Continuous analysis mode
-X
Analyse even when the test succeeded.
VERSION
This man page is correct for version 4.0 of the Samba suite.
SEE ALSO
Samba
AUTHOR
This utility is part of the Samba[1] suite, which is developed by the global Samba Team[2].
gentest was written by Andrew Tridgell.
This manpage was written by Jelmer Vernooij.
NOTES
1. Samba
http://www.samba.org/
2. Samba Team
http://www.samba.org/samba/team/
Samba 4.0 06/17/2014 GENTEST(1)