Please who can explain to me how to create a database with tables with Oracle? I installed Oracle 10g and is it possible to create database without code like with ms sql server in management studio just clicking Create database, create table...?
You can create a database without code by using the DBCA (Database Configuration Assistant). Can you find under Programs | <Oracle Home> | Migration and Configuration Tools
You have to create table though code, unless you use a third-party WYSIWYG tool.
create table t1
( id number,
name varchar2
)
/
The forward slash is like the GO statement in SQL Server.
I have found Database Configuration Assistant and I followed many steps to create the database. AT the end I have not seen a concreate database in wich i could create tables, can you help me to do so?
When you used the DBCA to create the database you had to type in what the password would be for the SYS, SYSTEM users. You also would have chosen a name for your database. Did you write these down?
If not you should be able to log into the database, provided it is the only Oracle database on you server.
I did it.I went to Enterprise Management through
http://mycomputer:1158/em I found my database, I created a table but Ia can not add a data into a database.How can I do that from Enterprise Management or but another way?
pol11
Member
2 Points
9 Posts
How to create database with Oracle
May 05, 2009 02:34 PM|LINK
Please who can explain to me how to create a database with tables with Oracle? I installed Oracle 10g and is it possible to create database without code like with ms sql server in management studio just clicking Create database, create table...?
Thanks [:)]
asplive
Member
86 Points
67 Posts
Re: How to create database with Oracle
May 05, 2009 04:50 PM|LINK
Yes, you are right.
create database database name
Then
create table tablename
dweezil
Participant
1873 Points
395 Posts
Re: How to create database with Oracle
May 05, 2009 11:31 PM|LINK
You can create a database without code by using the DBCA (Database Configuration Assistant). Can you find under Programs | <Oracle Home> | Migration and Configuration Tools
You have to create table though code, unless you use a third-party WYSIWYG tool.
create table t1
( id number,
name varchar2
)
/
The forward slash is like the GO statement in SQL Server.
SELECT * FROM users WHERE clue = 'yes';
Records found: 0
wmec
Contributor
6228 Points
3226 Posts
Re: How to create database with Oracle
May 06, 2009 02:09 AM|LINK
You can download Oracle database and Oracle client and then setup both. Further you can create user, create table and etc., through Sql*plus.
HuaMin Chen
pol11
Member
2 Points
9 Posts
Re: How to create database with Oracle
May 06, 2009 12:29 PM|LINK
Hi Dweezil,
I have found Database Configuration Assistant and I followed many steps to create the database. AT the end I have not seen a concreate database in wich i could create tables, can you help me to do so?
Thanks[:)]
pol11
Member
2 Points
9 Posts
Re: How to create database with Oracle
May 06, 2009 12:33 PM|LINK
Hi wmec,
when I open sql plus it is asked the user name, the password and the ligne of connection.Where should I find these or what should I type there?
Thanks
dweezil
Participant
1873 Points
395 Posts
Re: How to create database with Oracle
May 06, 2009 02:53 PM|LINK
You should be able to logged to SqlPlus with:
/ "as sysdba"
Once you log in you will want to a user account
SELECT * FROM users WHERE clue = 'yes';
Records found: 0
wmec
Contributor
6228 Points
3226 Posts
Re: How to create database with Oracle
May 07, 2009 01:55 AM|LINK
Have you downloaded Oracle DB and have set up that? When setting up it, you'll be prompted to provide your own preferred sys/system passwords.
HuaMin Chen
dweezil
Participant
1873 Points
395 Posts
Re: How to create database with Oracle
May 07, 2009 02:08 AM|LINK
When you used the DBCA to create the database you had to type in what the password would be for the SYS, SYSTEM users. You also would have chosen a name for your database. Did you write these down?
If not you should be able to log into the database, provided it is the only Oracle database on you server.
Log in like this,
sqlplus “/ as sysdba”
Let me know if this worked.
SELECT * FROM users WHERE clue = 'yes';
Records found: 0
pol11
Member
2 Points
9 Posts
Re: How to create database with Oracle
May 09, 2009 07:59 AM|LINK
Thanks Dweezil,
I did it.I went to Enterprise Management through http://mycomputer:1158/em I found my database, I created a table but Ia can not add a data into a database.How can I do that from Enterprise Management or but another way?
Thanks