Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 11, 2009 06:44 AM by pol11
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...?
May 05, 2009 04:50 PM|LINK
Yes, you are right.
create database database name
create table tablename
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,
The forward slash is like the GO statement in SQL Server.
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.
May 06, 2009 12:29 PM|LINK
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?
May 06, 2009 12:33 PM|LINK
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?
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
create user dweezil identified by letmein
default tablespace users
temporary tablespace temp
quota unlimited on users
account unlock ;
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.
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.
May 09, 2009 07:59 AM|LINK
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?