重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-01682: read-only DB cannot allocate temporary space in tablespace string [打印本页]

作者: admin    时间: 2016-7-18 14:58
标题: ORA-01682: read-only DB cannot allocate temporary space in tablespace string
ORA-01682: read-only DB cannot allocate temporary space in tablespace string
Cause: Temporary space (usually for sorting) could not be allocated in either main
storage or a tempfile. An attempt was made to allocate the space from the
tablespace named, but the database is opened read-only. The database open
requires a sort work space.
Action: Either allow sufficient workspace in main storage (SORT_AREA_SIZE
initialization parameter), or create a temporary tablespace before making the
database read-only. Use ALTER TABLESPACE ADD TEMPFILE statement to add
temporary files to the temporary tablespace.






欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2