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

gijovarghese_at_yahoo.com (Gijo Varghese) wrote:

(>I was not asking about sqlplus..) What? then what does this mean:  ' Is it possible to do the same operation with sqlplus?' or ' >Using sqlplus' It seems you are asking about SqlPlus...

To connect to any database instance from SqlPlus you can use the SqlPlus user/password_at_instancealiasintnsnamesorafile

You can then do anything on that instance that you have been granted permission to do by its DBA - Usually this will NOT include creating a database since to do that you must connect as SYSDBA to an instance that has no existing database ( or one you can safely trash) and run a series of Sql scripts to create and configure it - you can , if given permission, create users and schemas however...Creating Tables, etc is NOT the same as creating a database, that is a SqlServer ( and some other databases like Access) concept and it is very different in Oracle.

>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]
>
>
>
>"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 - 11:21:45 CST