Saturday, August 1, 2009

how can i create Tablespace?

we can create a simple tablespace in oracle by
create tablespace tablespacename datafile 'datafilelocation' size 100m;
view name of the tablespace
select name from v$tablespace;