Need to setup Database ?

[chz013]

Hi
I'm new to oracle.
Must I create a database before I could create
tables for practice ? this is my experience with
mysql.
Any help is fully appreciated.

 

[sem]

Yes. Of course if you mean Oracle database and do not mix it up with SCHEMA, TABLESPACE, INSTANCE Oracle terms.

Regards, Dima

 

[chz013]

Dima
Thanks for your response but I'm still getting the answers I needed.

Do I have to create a database (like in mysql using
create database in order to create tables in that
database ?
Or
Is tablespace in oracle suffices to create tables ?
If so, how does oracle know how these new tables I create
belong to this tablespace ?

Lastly,
I dont understand the point of
connect internal;
command.

Must I connect internal first before I could create any tables ?

Advance thanks for help

 

[Turkbear]

Hi,
You need to read much more before attempting to
move to Oracle - it is much more complex than MySql.

Go to

http://tahiti.oracle.com

and review the docs on Concepts and the Administrator's Guide ( at a minimum ) - you may need to register ( do so, it is free, they don't reveal your address and you will need it often )

In general:
Connect internal ( which is no longer supported in v9)
connects you as a DBA to the Oracle service to allow for the starting/stopping of any created Oracle instances
(created by the DCA or with the oradim command )

Once an instance is created then tablespaces, users, etc can be created - it is when you set default settings for users that you determine in which tablespace their objects will be created in - so you need to create at least 2 additional tablespaces - one for their data and one for temporary use ) so that the system tablespace ( which is the only one created when the instance is )is NEVER used for user-related stuff..

More than that is too complex for a posting, but read,read,read
..then act...
Happy learning...

 

[sem]

You don't need to CREATE DATABASE in the only one case : you already have one. Though, if you successfully connected to Oracle INSTANCE as an ordinary user, this is the case.

Regards, Dima