怎么在ORCLE建立表空间？

如何在ORCLE建立表空间？？？？？？
我是初学者 该怎么 在ORCLE 中建立表空间 各位前辈指点下 ！！！！还有 如何在 写SQL*PLUS时不删除字符后退光标

------解决方案--------------------


Creating a Bigfile Tablespace: Example 
The following example creates a bigfile tablespace bigtbs_01 with a datafile bigtbs_f1.dat of 10 MB:

CREATE BIGFILE TABLESPACE bigtbs_01
DATAFILE 'bigtbs_f1.dat'
SIZE 20M AUTOEXTEND ON;
Creating an Undo Tablespace: Example 
The following example creates a 10 MB undo tablespace undots1:

CREATE UNDO TABLESPACE undots1
DATAFILE 'undotbs_1a.f'
SIZE 10M AUTOEXTEND ON
RETENTION GUARANTEE;
Creating a Temporary Tablespace: Example 
This statement shows how the temporary tablespace that serves as the default temporary tablespace for database users in the sample database was created:

CREATE TEMPORARY TABLESPACE temp_demo
TEMPFILE 'temp01.dbf' SIZE 5M AUTOEXTEND ON;

------解决方案--------------------
这个就可以了。

探讨

Creating a Bigfile Tablespace: Example
The following example creates a bigfile tablespace bigtbs_01 with a datafile bigtbs_f1.dat of 10 MB:

CREATE BIGFILE TABLESPACE bigtbs_01
DATAFILE 'bigtbs_f1.dat'
SIZE 20M AUTOEXTEND ON;
Creating an Undo Tablespace: Example
The following example creates a 10 MB undo tablespace undots1:

CREATE UNDO TABLESPACE undots1
DATAFILE 'undotb…