創(chuàng)建表空間失敗，請各位幫忙分析！

zhmg

lv_TELESALE_07的大小為256M，執(zhí)行下面這個(gè)命令失敗，并且lv_TELESALE_07這個(gè)文件也看不到了。

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

是你的 磁碟問題 ...

磁片有壞塊或是 空閑空間不夠。。 試著建立小一點(diǎn)的數(shù)據(jù)文件..

zhmg

執(zhí)行以下命令，問題解決，謝謝大家！

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;