创建表空间失败，请各位帮忙分析！

zhmg

lv_TELESALE_07的大小为256M，执行下面这个命令失败，并且lv_TELESALE_07这个文件也看不到了。

SQL> CREATE TABLESPACE TELESALE_LOGDATA
  2     DATAFILE '/dev/lv_TELESALE_07' SIZE 200M REUSE  
  3     LOGGING
  4     ONLINE
  5     PERMANENT
  6     EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
CREATE TABLESPACE TELESALE_LOGDATA
*
ERROR at line 1:
ORA-19502: write error on file "/dev/lv_TELESALE_07", blockno 3201
(blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "/dev/lv_TELESALE_07", blockno 3073
(blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 1048576

[ 本帖最后由 zhmg 于 2006-7-17 16:28 编辑 ]

zhang_yong88

是你的 磁碟問題 ...

磁片有壞塊或是 空閑空間不夠。。 試著建立小一點的數據文件..

zhmg

执行以下命令，问题解决，谢谢大家！

CREATE TABLESPACE TELESALE_MAININDEX
  2     DATAFILE '/dev/rlv_TELESALE_04' SIZE 250M REUSE,
  3              '/dev/rlv_TELESALE_05' SIZE 250M REUSE
  4     LOGGING
  5     ONLINE
  6     PERMANENT
  7     EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;