解决方法:使用“Alter TABLESPACE ADD DATAFILE”命令增加文件系统文件和原始分区,或者增加INITIAL的大小(如:alter tablespace CDRS101 default storage(next 500M pctincrease 1))应该能够解决,否则就是有人使用你的表空间上创建了一个比较大的数据文件导致你的表空间不够用。
24.ORA-1688: unable to extend table RMMCDR.LOCAL_CDR partition LOCAL_CDR101 by 460800 in tablespace CDRS101
相应的英文如下:
Cause: An extent could not be allocated for a table segment in tablespace
Action: Use the Alter TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace
25.错误提示:FRM-41839:在临时记录缓冲区文件/tmp/ztYpaa.tmp中磁盘的输入/输入错误
原因:是/TMP目录的空间用完了
解决办法:(从metalink上找的)
fact: oracle Application Object Library
symptom: FRM-41839: Disk I/O error on temporary record buffer file
/var/tmp/AAAJGaa9Z.TMP
symptom: Querying Values in a value set/Rows in row sets
change: NOTE ROLE: Also note that per Note 157385.1, this error occurs when
a query is performed which returns a large number of records. Forms is trying
to create a temporary file in which to place the results of the query. There
is not enough disk space on the drive which is assigned to TEMP/TMP. Either
cause: The /var/tmp referenced in the error message was on Web/Forms
tier.
fix:
There are 3 possible solutions:
1. Create a soft link to a mount point with more disk space
2. Add more disk space.
3. Set the TMPDIR environment variable and manually start the forms server. See
有些解决方案一下子记不得出处了,感谢提供解决方案的作者,谢谢。
PL/SQL显示行号:
tools> preferens >userinterface >editor >other
Check display line numbers
orA-00972: identifier is too long.
*Cause: An identifier with more than 30 characters was specified.
*Action: Specify at most 30 characters.
应该是表空间名超过了30个字符。命名过长
PLS-00428: an INTO clause is expected in this Select statement