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.
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.
ASKER
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.
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.
ASKER
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.
:)
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.
:)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
:)
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.
:)
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?