Re: SOS: URGENTLY SEEKING HELP

Hi,

 oradim gives you a gui to create a new database. You need to have a init<SID>.ora file (copied from the starter - database for example).

 Then you can specify filenames, locations, passwords etc.

 Oradim will create windows services, database for you.

 There should be an icon to start it somewhere.

Karsten

In article <81m8pu$5dq4_at_imsp212.netvigator.com>,   "Ah So" <cwso7_at_netscape.net> wrote:
> l do really appreciate your information. But would you mind provding
me with
> more specific information how to use the "oradim73" ?.
>
> regards
> Ah So
>
> <karsten_schmidt8891_at_my-deja.com> wrote in message
> news:81m2oi$b9l$1_at_nnrp1.deja.com...
> > Hi,
> > you can use sql*plus exactly the same way on windows and unix.
> > create user ....
> > create or replace trigger ... etc works fine.
> >
> > your sql-plus scrips from unix should work as well (apart from host
> > commands).
> >
> > there is also a gui for administrative tasks (Oracle enterprise
> > manager) - you need to install that.
> >
> > to create a database, either use your scripts from unix, or run
oracle
> > instance manager (oradim73 or so...)
> >
> > Karsten
> >
> > In article <81jqgq$c3d1_at_imsp212.netvigator.com>,
> > "Ah So" <cwso7_at_netscape.net> wrote:
> > > Hi
> > >
> > > l have some experience in Oracle on Unix. But, l am new to the
> > environment
> > > of oracle on NT
> > > After installing oracle 7.3.4 on NT, l found there are many tools
> > under
> > > Oracle
> > > program group. But it seems that none of them let me to
administer and
> > > manage (e.g create DB, create table, compile stored procedure or
> > trigger)
> > > the Database as the SQL server's Enterprise manager does.
> > > Does oracle server really not provide any tools for abovementioned
> > > operations
> > > (exclude third-party tool)
> > >
> > > So l tried to use SQLPlus* as l did on Unix. But l have no idea
about
> > > how to compile my stored procedure and trigger.
> > > May someone introduce me some basic skills of Oracle on window NT
???
> > >
> > > 1) How to compile a trigger / stored procedure using SQLPlus* or
other
> > > free tools installed along with Oracle server.
> > > 2) How can l create a DATABASE and a USER ACCOUNT using SQLPlus*
or
> > other
> > > free tools installed along with Oracle server.
> > > 3) How can l write a script which kick off the stored procedure in
> > Oracle
> > > DB.
> > >
> > > If convenient, please also send your reply to cwso7_at_netscape.net
> > >
> > > Your help is highly appreciated and Thanks a lot
> > >
> > > regards
> > > Ah So
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 29 1999 - 03:45:48 CST