表空间扩展.doc

表空间扩展说明 17:58:05 执行SQL语句异常！ insert into DC_FILE_REC(file_log_id,link_id,source_path,source_file,dcm_file_id,switch_id,exchange_id,fi) 17:58:05 SQL异常信息 ： java.sql.SQLException: ORA-01654: unable to extend index DICDCM.IDX_FILE_REC4 by 1024 in tablespace DICDCMX 17:58:05 free database connector! 17:58:05 分发链路 : tuoji-etsmet-c ： 写文件分发日志表异常 : /bill2/met/bjets/data/USRMETER1H 17:58:05 create database connector! 用户：system 密码：manager 从后台进入sql操作 #sqlplus ‘/ as sysdba’输入用户名密码即可 1、 SQL desc dba_segments; Name Type Nullable Default Comments OWNER VARCHAR2(30) Y Username of the segment owner SEGMENT_NAME VARCHAR2(81) Y Name, if any, of the segment PARTITION_NAME VARCHAR2(30) Y Partition/Subpartition Name, if any, of the segment SEGMENT_TYPE VARCHAR2(18) Y Type of segment: TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY,SPACE HEADER, TYPE2 UNDO or CACHE TABLESPACE_NAME VARCHAR2(30) Y Name of the tablespace containing the segment HEADER_FILE NUMBER Y ID of the file containing the segment header HEADER_BLOCK NUMBER Y ID of the block containing the segment header BYTES NUMBER Y Size, in by