Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Command line utility for Oracle 8i/9i table creation on Solaris.[like osql.exe for MSSQL]

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

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 8 Jan 2003 13:38:59 -0800
Message-ID: <336da121.0301081338.6456fed@posting.google.com>


gijovarghese_at_yahoo.com (Gijo Varghese) wrote in message news:<f94477e9.0301080413.400ba429_at_posting.google.com>...
> 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?
>

Absolutely.

> 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.]
>

You want to create tables or create database? These are different (very) operations in Oracle.

> 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]
>
>
>
> "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<NgdS9.1108$V6.1449_at_news.indigo.ie>...
> > It's nice to see a question like this once in a while :)
> > "Volume WU Actual" <TopUpThe_at_volume.co.uk> wrote in message
> > news:av6b8o$bbu$1_at_nsnmrro2-gest.nuria.telefonica-data.net...
> > >
> > > > It's called sqlplus, and it's a command line tool.
> > > >
> > > > Regards
> > >
> > >
> > > Thank you very much!!!
> > >
> > > secobau_at_teleco.upv.es
> > > franuria_at_terra.es
> > >
> > >
Received on Wed Jan 08 2003 - 15:38:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US