oracle and mysql creating of database/scheme and tables

Posted on 2008-11-10
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
    LVL 23

    Expert Comment

    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

    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


    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

    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

    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

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now