I am a newbie in Oracle databases and compared with my experiences with SQL Server and MySQL, Oracle is not as easy. Question is, when I tried to create a database using DB Configuration Assistant, when I look at the database using SQL Developer, there are already tables on it. Why does it have something like system tables on it if its a custom database. How can I instead put my own tables on that database.
3
-
1Are you sure you need a new database? Usually a database in MySQL and SQL Server maps to a user in Oracle. A "database" in Oracle is (more or less) the whole installation. It is something completely different than a "database" in SQL Server or MySQLuser330315– user3303152012-11-05 08:09:20 +00:00Commented Nov 5, 2012 at 8:09
-
im not sure to be honest. what i do want is to have a db in oracle the same as i have a db in mysql/sql server where i can create table, views, enter data, etc.SleepNot– SleepNot2012-11-05 08:41:12 +00:00Commented Nov 5, 2012 at 8:41
-
2If you already have a running Oracle instance, you also have a database. Just create a user and create the tables after connecting with that user.user330315– user3303152012-11-05 08:42:30 +00:00Commented Nov 5, 2012 at 8:42
Add a comment
|
2 Answers
Please read the Oracle documentation. It is comprehensive, online and free. I understand the size of it may be dauting compared to the relative pamphlet which constitutes the docs for MSSQL :) but as you will find out Oracle does a lot more.
To get you started there is a 2-Day DBA Guide. Find it here. This has chapters on creating the database (which maybe you should have read already) and administering users, which will address your immediate concerns.
Comments
You shoud begin connecting as sys and creating a user(and implicitly, a schema). In that schema you can put your tables.
5 Comments
SleepNot
I see. Ill get back to see after I create another user for that DB.
SleepNot
can you advise me what role should i grant a user to be able to create a database and do CRUD on it.
Florin Ghita
you have an Oracle database installed and I think is up. If you created the user and conected with that user you can't create tables(I don't know the default behavior - but I believe this won't happen), you may run an
grant create table to your_username;SleepNot
thanks. I have got in to that part. problem is, when I create a table using 'system' user and grant it to 'my_user'... the table doesnt seem to show up on my_user's connection.
Florin Ghita
First, you should not create a table with user system or in tablespace SYSTEM. Second, If you grant
select on your_sys_table to your_user, you'll be able to read from it. For insert you should grant insert.