Creating tables
To create a new table in our database, we use the CREATE TABLE statement. It’s very similar to the sentence in oder database systems. But in Oracle we can specify some Oracle specific features such as the storage or the tablespace.
Here it is an example of use of the CREATE TABLE statement.
CREATE TABLE AYUDA
(
ID NUMBER(10) NOT NULL,
FIELD1 NUMBER(10),
FIELD2 VARCHAR2(250 BYTE)
)
TABLESPACE myTablespace
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL
MONITORING;