oracle and mysql creating of database/scheme and tables

Posted on 2008-11-10
Medium Priority
Last Modified: 2012-05-05
oracle and mysql creating of database/scheme and tables:


In mysql database system, the creating of database/scheme is very simple with no hassle.
Making a table in mysql is so simple also.

Mysql database system Procedure:
<scheme Name>
              <Table Name>
                        <Field Name>

mysql connection to .net: is simple to.
Protected Const lCon1Str As String = "server=" & "localhost" & ";" _
            & "port=" & "3306" & ";" _
            & "user id=" & "root" & ";" _
            & "password=" & "" & ";" _
            & "database=Nclient"

About some connections, I refer this website: but still complicated in oracle, either XE or with tns or not.

I have read some oracle database documentation, but it did not get the point of making databases such as mysql do.

CAN some one clear this to me on the proper making of oracle scheme then the tables.  I have install oracle XE, oracle 10g home, oracle ODAC, with that installation I could not start because the accessing system of oracle is so confusing.

I have tested oracle since 1998, then I don't like it, but now I'll try for luck.

Gash on this time I hate oracle database system procedure, its so complicated and confusing.

I hope someone get my point.

Question by:rionroc
  • 3
  • 2
LVL 23

Expert Comment

ID: 22922363
I regret you've had such difficulty, and am pleased you're willing to reconsider.
Curiously, in your example, your session connects as "root" -- generally not something you want any or all users to do.  But the similarity is there.  During the database creation, certain privieged accounts are created automatically, such as SYS.  Using this pre-created account, the DBA will create additional user accounts, having certain constraints and permissions.  Because a box may host multiple databases, there is a unique identifier or service_name.  In your example, "Nclient".  A database uses user accounts as logical containers of objects such as tables and indexes;  another name for such containers is schema.  Therefore a database contains multiple schemas:  the automatic ones, and the manually created ones.  
Another aspect of the database is that tables and similar objects are logically contained in a tablespace.  A tablespace, by the way, is physically represented by one or more data files on the host.
The database security requires each user account to have some authentication method such as a password.  A user account is assigned at creation to a default tablespace for its objects (such as USERS); and a default tablespace for temporary / sort segments (such as TEMP).
In order for a client PC to connect with a database, the client request must contain the host name, the database (service) on that host, and the physical port the request will use on the host.  Again, just as you have in your example.
How may I assist further?
LVL 12

Author Comment

ID: 22922604
Hello dvz

thanks for the quick reply.

As I know tablespace is when you create a *.dbf,
and a .dbf is a table for mysql, because the database or scheme of mysql is a folder itself and the tables are inside the folder.   Thats mysql.

What about oracle?

As I know also for oracle the default database is ORCL, I have create another database called handset but I don't know where should the tables to be put.

As I know also, if I create a user it would be the scheme itself or database.

I'm really confuse.

What are the procedure if I create 2 database, and each database will have 3 tables?  Where?  What should I do to make it simple?


LVL 12

Author Comment

ID: 22937080

I write wrong, *.dbf are tables of dbase,foxpro,foxbase.

But what about database, a database for mysql is a folder, and what about oracle?

I was hoping the oracle system database was like mysql.

Is the .dbf for the database and the table itself of oracle?

Whats the point of oracle system database?

I hope there is a true EE expert can solve my problem.

Great is our GOD.
LVL 23

Accepted Solution

David earned 1500 total points
ID: 22949378
I respect that the asker holds the opinion that 48 hours is a long time to wait for a solution.  As a zone expert and cleanup volunteer my perspective is different and as such, I cannot agree that this was neglected.  Had the question remained open I would have replied to the followup question that was posted just after midnight this morning.  FWIW, rionroc, the physical *.dbf data files are associated with one and only one logical tablespace.   A tablespace is associated with the objects of one or more schemas.  The sequence of creation is database with a system tablespace and its physical *.dbf files; additional tablespaces with data files; additional users; and additional objects owned by users.  HTH.
As it is, I suggest my answer 22922363 spoke to the issue of schema and table creation.
LVL 12

Author Comment

ID: 22957532
Hello dvz

I am comparing the database system of oracle and mysql.

A database or scheme for mysql is a folder.

A schema/schemas for oracle is a user.

Anyway I'm suffering studying oracle database system, just like what I did in the past 1998, but now I agree to overcome this confuseness.

If I close this post without giving points nothing will change.  If I close this post giving points is accepting your kind heart in helping.
I should reward you the points no matter your answers are not completly detailed.

Thanks for helping.

Great is our GOD.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question