OracleEBS开发错误集锦(四)

2014-11-24 16:55:47 · 作者: · 浏览: 3
扩展。

解决方法:使用“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
free up more space or move the TEMP directory to a different drive.
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