|
|
Re: how to create database and table ? [message #534918 is a reply to message #534842] |
Sat, 10 December 2011 03:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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!
|
|
|
|
|
|
|
|
|
|
|
|