You can script the creation of a database, or use the database assistant to
make one, if the database is already there then just use it. In Oracle an
instance has 1 database and a database has multiple schemas. You probably
really want a schema.
Just create an owner (user) and login as that user and create your stuff.
On ton.oracle.com is all the documentation. You have to sign up as a
registered user, but it is free. You can probably find an Oracle for
dummies book that will give you the basics, but I would just read the
manual. It is organized as a series of books.
Jim
"eugene kim" <eugene1977_at_hotmail.com> wrote in message
news:akspfp$ft0$1_at_newsreader.mailgate.org...
> hi
> in postgresql
>
> i would
> createdb mydb --> create database named mydb
> psql mydb --> connect to mydb
> create table mytable blah blah;
> \d --> shows what table i have in this db
>
>
> i can't find how to do any of these three in oracle 9i..
> --;
> thx in advance
> and is there a good concise tutorial or book for a novice
> such as 'practical postgresql' for postgresql
>
> thanks
Received on Sun Sep 01 2002 - 10:21:00 CDT
