SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 7月 11 10:13:26 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> CREATE TABLESPACE epet_tablespace
2 DATAFILE 'E:\oracle\product\10.2.0\oradata\MAIN\EPET.DBF'
3 SIZE 100MB
4 AUTOEXTEND ON NEXT 32MB MAXSIZE UNLIMITED
5 LOGGING
6 EXTENT MANAGEMENT LOCAL
7 SEGMENT SPACE MANAGEMENT AUTO;
SIZE 100MB
*
第 3 行出现错误:
ORA-02180: 无效的 CREATE TABLESPACE 选项
SQL>
SQL> CREATE TABLESPACE epet_tablespace
2 DATAFILE 'E:\oracle\product\10.2.0\oradata\MAIN\EPET.DBF'
3 SIZE 100MB;
SIZE 100MB
*
第 3 行出现错误:
ORA-02180: 无效的 CREATE TABLESPACE 选项
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 7月 11 15:06:53 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> CREATE TABLESPACE epet_tablespace
2 DATAFILE 'E:\oracle\product\10.2.0\oradata\MAIN\EPET.DBF'
3 SIZE 100M;表空间已创建。SQL> 为什么不能是 MB? 我挺郁闷