How To Create A Tablespace And Index ?

[xakoum]

salam,

how to create a tablespace and index in oracle  for this :

 

 
  ACT_TBL – ACT Table space of 30GB
  ACT_INX – Index space of 12 GB
  Maximum Cursor – 2048

 

and thanks in advanced guys

 

[Ahmed.Hamdy]

 

to create tablespace --

 as dba--

CREATE TABLESPACE Ahmed

DATAFILE ahmed.dbf

SIZE 20M

autoextend on 

ONLINE;

to create index

create index index_name

  on table_name (column_name)  --as schema owner

 

[sami_oradba1]

لا يوجد شئ أسمه Max Cursor
 

في Parameter أسمه open_cursors

To change the Value for this Parameter 
 

Alter system set open_cursors=500 scope=both;