怎么在ORCLE建立表空间?

如何在ORCLE建立表空间??????我是初学者 该怎么 在ORCLE 中建立表空间 各位前辈指点下!!!!还有 如何在 写S

如何在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…