一份数据量近三亿的数据从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.