oracle and mysql creating of database/scheme and tables

oracle and mysql creating of database/scheme and tables:

Hello

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.
http://www.connectionstrings.com/


I have read some oracle database documentation, but it did not get the point of making databases such as mysql do.
http://thomas.eibner.dk/oracle/basicdba/
http://www.oracle.com/technology/pub/articles/cook_dotnet.html



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.

Thanks.
LVL 12
rionrocAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidSenior Oracle Database AdministratorCommented:
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?
rionrocAuthor Commented:
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?


Thanks.


rionrocAuthor Commented:
Ops!

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.
:)
DavidSenior Oracle Database AdministratorCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rionrocAuthor Commented:
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.
:)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.