You must have the CREATE TABLESPACE system privilege. To create the SYSAUX tablespace, you must have the SYSDBA system privilege.Before you can create a tablespace, you must create a database to contain it, and the database must be open.To use objects in a tablespace other than the SYSTEM tablespace:If you are running the database in automatic undo management mode, then at least one UNDO tablespace must be online. If you are running the database in manual undo management mode, then at least one rollback segment other than the SYSTEM rollback segment must be online.
创建表空间也需要往系统表里写数据,mount时数据文件没打开,系统表也无法使用
TEST
SQL> startup mount;
ORACLE 例程已经启动。Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 79692480 bytes
Database Buffers 201326592 bytes
Redo Buffers 7139328 bytes
数据库装载完毕。
SQL> create tablespace test1 datafile 'e:\1.oea' size 5M;
create tablespace test1 datafile 'e:\1.oea' size 5M
*
第 1 行出现错误:
ORA-01109: 数据库未打开
If you are running the database in manual undo management mode, then at least one rollback segment other than the SYSTEM rollback segment must be online.