打开sqlsplus.exe,一般在D:\oracle\product\10.2.0\db_1\BIN路径下
1、首先输入用户名密码连接数据
Enter user-name: conn /as sysdba
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
2、再次连接
SQL> conn /as sysdba
Connected.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01531: a database already open by the instance
3、创建索引命令
create index req_date_time_index on 表名(字段名 asc)
*
ERROR at line 1:
ORA-01408: such column list already indexed
4、查看sort_area_size的值
SQL> show parameter sort_area_sizeNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sort_area_size integer 65536
5、查看workarea_size_policy的值
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
workarea_size_policy string AUTO
6、设置workarea_size_policy的值
SQL> alter system set workarea_size_policy=MANUAL scope=spfile;
System altered.
7、设置sort_area_size的值
SQL> alter system set sort_area_size=65535000 scope=spfile;
System altered.
设置之后需要重启服务或者重启电脑才能生效。