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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-01682：只读DB无法在表空间字符串中分配临时空间,
.原因：无法在主存储或临时文件中分配临时空间（通常用于排序）。尝试从名为的表空间中分配空间，但数据库以只读方式打开。数据库打开需要一个排序工作空间。,
.操作：在使数据库为只读前，在主存储器中（SORT_AREA_SIZE初始化参数）允许足够的工作空间，或创建临时表空间。使用ALTER TABLESPACE ADD TEMPFILE语句将临时文件添加到临时表空间。,
.

aiaiDBA

13718043309

010-86462881

ORA-01682: read-only DB cannot allocate temporary space in tablespace string

1 个回答

相似问题