内容发布更新时间 : 2024/12/28 13:01:55星期一 下面是文章的全部内容请认真阅读。

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Connected as system

SQL> select * from v$tablespace 2 select * from v$tablespace;

select * from v$tablespace select * from v$tablespace

ORA-00933: SQL 命令未正确结束

SQL> SELECT * FROM V$TABLESPACE;

TS#

NAME

INCLUDED_IN_DATABASE_BACKUP BIGFILE FLASHBACK_ON ENCRYPT_IN_BACKUP

---------- ------------------------------ --------------------------- ------- ------------ -----------------

0 SYSTEM YES NO YES

1 UNDOTBS1 YES NO YES

2 SYSAUX YES NO YES

4 USERS YES NO YES

3 TEMP NO NO YES

SQL> SELECT TABLESPACE_NAME AS SYSTEM,SUM(BYTES) 2 FROM DBA_DATA_FILES 3 GROUP BY TABLESPACE_NAME;

SYSTEM SUM(BYTES) ------------------------------ ----------

SYSAUX 251658240 UNDOTBS1 26214400 USERS 5242880 SYSTEM 503316480

SQL>SELECT TABLESPACE_NAME AS USERS,SUM(BYTES) SQL> SELECT TABLESPACE_NAME AS USERS,SUM(BYTES) 2 FROM DBA_DATA_FILES 3 GROUP BY TABLESPACE_NAME;

USERS SUM(BYTES) ------------------------------ ----------

SYSAUX 251658240 UNDOTBS1 26214400 USERS 5242880 SYSTEM 503316480

SQL> CREATE TABLESPACE USER1

2 DATEFILE'D:\\ORACLE\\USER1.DBF' SIZE 50M 3 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE USER1

DATEFILE'D:\\ORACLE\\USER1.DBF' SIZE 50M EXTENT MANAGEMENT LOCAL AUTOALLOCATE

ORA-02180: 无效的 CREATE TABLESPACE 选项

SQL> CREATE TABLESPAE ORACLE1

2 DATAFILE 'D:\\ORACLE\\ORACLE1.DBF' SIZE 50M 3 EXTENT MANAGEMENT LOCAL AUTOALLOCATION;