ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle ORA错误码

Oracle ORA错误码

原创 Linux操作系统 作者:wangxuanping 时间:2011-06-29 10:34:58 0 删除 编辑

   一份数据量近三亿的数据从table拉至PSA时,发生了异常,12个小时的

功劳白费了。上网查看资料,主要都是涉及表空间(tablepaces),归纳了几点,共

参考。

 

ORA-01653: 表.无法通过(在表空间中)扩展 ||ORA-01653_unable_to_extend_table_string.string_by_string_in_tablespace_string

Oracle Database Error ORA-01653

ORA-01653 unable to extend table string.string by string in tablespace string


问题

Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.


解决

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.


ORA-01688: 表.分区无法通过(在表空间中)扩展 ||ORA-01688_unable_to_extend_table_string.string_partition_string_by_string_in_tablespace_string

Oracle Database Error ORA-01688

ORA-01688 unable to extend table string.string partition string by string in tablespace string


问题

Failed to allocate an extent of the required number of blocks for table segment in the tablespace indicated.


解决

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

 

ORA-01654: 索引.无法通过(在表空间中)扩展 ||ORA-01654_unable_to_extend_index_string.string_by_string_in_tablespace_string

Oracle Database Error ORA-01654

ORA-01654 unable to extend index string.string by string in tablespace string


问题

Failed to allocate an extent of the required number of blocks for an index segment in the tablespace indicated.


解决

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

ORA-01655: 群集 . 无法通过 (在表空间 中) 扩展 ||ORA-01655_unable_to_extend_cluster_string.string_by_string_in_tablespace_string

Oracle Database Error ORA-01655

ORA-01655 unable to extend cluster string.string by string in tablespace string


问题

Failed to allocate an extent of the required number of blocks for a cluster segment in tablespace indicated.


解决

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

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

上一篇: 新工作杂说
下一篇: SID Table
请登录后发表评论 登录
全部评论

注册时间:2009-09-02

  • 博文量
    34
  • 访问量
    76587