Home » Infrastructure » Windows » how to create database and table ?
icon5.gif  how to create database and table ? [message #534841] Fri, 09 December 2011 09:55 Go to next message
comptech
Messages: 14
Registered: December 2011
Junior Member
hi
how to create db in oracle 11g and make some table in that from the web page 'database control' ?
Re: how to create database and table ? [message #534842 is a reply to message #534841] Fri, 09 December 2011 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 23034
Registered: January 2009
Senior Member
>how to create db in oracle 11g
You already have a DB. Why do you need another?

>and make some table
Please post CREATE TABLE statement for this new table.
Re: how to create database and table ? [message #534918 is a reply to message #534842] Sat, 10 December 2011 03:38 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
how to create db in oracle 11g and make some table in that from the web page 'database control' ?

As people already told you on dBforums, a "database" you talk about is most probably a "schema" (or a "user") in Oracle.

Step by step: as a privileged user (such as SYS), issue the CREATE USER statement and grant privileges in order to make it possible to connect to the database (and create a table). First, check what tablespaces are available.
C:\>sqlplus sys/pwd@xe as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sub Pro 10 10:28:45 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDO
SYSAUX
TEMP
USERS
FLOW_1037931218715706

6 rows selected.

SQL> create user comptech
  2    identified by comp
  3    default tablespace users
  4    quota 10M on users;

User created.

SQL> grant create session,
  2        create table
  3  to comptech;

Grant succeeded.

SQL>

OK, now connect as a newly created user and create a table:
SQL> connect comptech/comp@xe
Connected.
SQL> create table test
  2    (id    number,
  3     ename varchar2(20)
  4    );

Table created.

SQL>

So far, so good. However, I have no idea what Quote:
in that from the web page 'database control'
means. What "web page"? What "database control"? Could you explain it?

There's a lot of reading for you; here's something to get started with. This is a 10g documentation (it is nice as it contains the "Most popular" section - read Concepts, 2 day DBA, Application Developer's Guide - Fundamentals and PL/SQL User's Guide and Reference and frequently consult SQL Reference book. (11gR2 documentation is behind that link).

Happy reading!
how [message #534970 is a reply to message #534841] Sat, 10 December 2011 15:28 Go to previous messageGo to next message
comptech
Messages: 14
Registered: December 2011
Junior Member
thank you very much.i mean web page that upload it.
can i perform create user and grant in sql developer?
i cant download the sql developer from oracle site. please put the download link.
  • Attachment: 1.jpg
    (Size: 296.22KB, Downloaded 113 times)
Re: how [message #535002 is a reply to message #534970] Sun, 11 December 2011 00:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes you can
2/ http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Regards
Michel
Re: how [message #535280 is a reply to message #535002] Tue, 13 December 2011 06:22 Go to previous messageGo to next message
comptech
Messages: 14
Registered: December 2011
Junior Member
i cant download from oracle site. please give me another download link.
thanks
Re: how [message #535283 is a reply to message #535280] Tue, 13 December 2011 06:24 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does "I can't" mean? Why can't you? Is there any error? What did you do, how did the site respond? (By the way, did you create an account?)
Re: how [message #535366 is a reply to message #535283] Tue, 13 December 2011 12:32 Go to previous messageGo to next message
comptech
Messages: 14
Registered: December 2011
Junior Member
i have account.
and error is:
we are unable to process your request. Please contact RPLS-Ops_ww@oracle.com if you believe you are receiving this notice in error

Whether there is another download link?
Re: how [message #535367 is a reply to message #535366] Tue, 13 December 2011 12:40 Go to previous messageGo to next message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are in Iran, you are not allowed to download Oracle products.
No one is able to help you without violating USA and some other countries law (for their citizens) or his contract with Oracle (for the other ones) and liable to prosecutions.

Regards
Michel
Re: how [message #547899 is a reply to message #535367] Sun, 18 March 2012 10:32 Go to previous messageGo to next message
Natanvay
Messages: 2
Registered: March 2012
Junior Member
Databases are main objects in MySQL. Every data is stored inside Databases. But it can not be stored directly inside it! Tables are used to store Related Data inside a Database. So basically, whenever we wish to store some data, then we need to create a Database and then a Table, and split that data into parts and store inside separate columns of the Table. A MySQL server can contain infinite amount of Databases, and a database can contain as many Tables you want.
Re: how [message #547903 is a reply to message #547899] Sun, 18 March 2012 13:50 Go to previous messageGo to next message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It was an Oracle question, so your answer is not appropriate here.

Regards
Michel
Re: how [message #552521 is a reply to message #547903] Thu, 26 April 2012 06:49 Go to previous message
gyver
Messages: 1
Registered: April 2012
Junior Member
it's really good.i wish to post it compex journal.
Previous Topic: how to find oracle patch
Next Topic: Oracle 11g Installation error occured
Goto Forum:
  


Current Time: Sun Nov 23 16:52:40 CST 2014

Total time taken to generate the page: 0.07607 seconds