ITPub博客

首页 > 数据库 > Oracle > ORA-1652错误有时候也会因permanent表空间不足而发生

ORA-1652错误有时候也会因permanent表空间不足而发生

原创 Oracle 作者:empo007 时间:2007-11-11 22:51:52 0 删除 编辑

Error: ORA-1652
Text: unable to extend temp segment by %s in tablespace %s

[@more@]

Cause: Failed to allocate an extent for temp segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated or create the object in another tablespace.
NOTE: A "temp segment" is not necessarily a SORT segment in a temporary tablespace.It is also used for temporary situations while creating or dropping objects like tables and indexes in permanent tablespaces.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/85922/viewspace-981792/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    126
  • 访问量
    1077475