Command line utility for Oracle 8i/9i table creation on Solaris.[ like osql.exe for MSSQL]

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 8 Jan 2003 12:35:01 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70322DE70@lnewton.leeds.lfs.co.uk>

Afternoon,

I have instances spread over 6 servers.

I can use sqlplus on any of the servers to access an instance on any other server provided that the tnsnames.ora file is correctly configured to allow traffic from that server to any of the others.

On my client PC running Windows, I can connect to any of the servers - because I have a tnsnames.ora configured to allow me to do so.

So assuming I have an instance called CMDB on host 'elmer', and I'm currently logged in on host 'wabbit' I simply do this :

        sqlplus user/password_at_cmdb

The tnsnames.ora file on host 'elmer' knows (!) that the cmdb instance is on host 'wabbit' and I'm connected with no problems.

Easy.

HTH Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: gijovarghese_at_yahoo.com (Gijo Varghese)
[mailto:gijovarghese_at_yahoo.com]

Posted At: Wednesday, January 08, 2003 12:13 PM Posted To: server
Conversation: Command line utility for Oracle 8i/9i table creation on Solaris.[like osql.exe for MSSQL]
Subject: Re: Command line utility for Oracle 8i/9i table creation on Solaris.[like osql.exe for MSSQL]

I was not asking about sqlplus..

Or in other words,

Using sqlplus, can I connect to a server running on another machine and create some tables on that?

for example with osql.exe , i can do like this:

from Machine A:

osql.exe user password MachineB-Server create.sql
[This will create database on machine B by running a sql script on
machine A.]

Is it possible to do the same operation with sqlplus?

[I may not be allowed to change /create any Oracle releated files on
Machine A.

Think this as a installation requirement with a product which creates its databae on a different machine from Installshield]   Received on Wed Jan 08 2003 - 06:35:01 CST