学习索引的相关知识,建立索引时报错:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> create index idx_test on tab_test(object_id) tablespace test;
create index idx_test on tab_test(object_id) tablespace test
*
第 1 行出现错误:
ORA-25153: 临时表空间为空
查看alter :
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP ----无数据文件
*********************************************************************
查看表空间:
SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
GHOST ONLINE
TEST ONLINE
HUNT ONLINE
SQL> select tablespace_name,file_name from dba_temp_files;
未选定行
增加数据文件:
SQL> alter tablespace temp add tempfile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\HUNT\T
EMP02.dbf' size 21M autoextend off;
表空间已更改。
SQL> create index idx_test on tab_test(object_id) tablespace ghost;
create index idx_test on tab_test(object_id) tablespace ghost
*
第 1 行出现错误:
ORA-01652: 无法通过 128 (在表空间 TEMP 中) 扩展 temp 段
SQL> alter database tempfile 'E:\oracle\product\10.2.0\oradata\hunt\TEMP02.DBF'
autoextend on next 100M;
数据库已更改。
---此处如果误用了alter database datafile 则报 ORA-01516: 不存在的日志文件, 数据文件或临时文件 的错。
SQL> create index idx_test on tab_test(object_id) tablespace ghost;
索引已创建。
SQL> commit;
提交完成。
转载于:https://blog.51cto.com/hunt1574/838901