QFS损坏，数据文件丢失的解决办法。

最新推荐文章于 2025-10-30 12:38:21 发布

最新推荐文章于 2025-10-30 12:38:21 发布 · 97 阅读

本文介绍了在Oracle数据库中如何使用exchange操作来交换分区表的数据，包括创建临时表、交换分区数据的具体步骤，并展示了如何重建索引以确保数据完整性。

普通表使用MOVE。分区表使用exchange.

BEFORE:
select count(*) from sgreports.metric_data_daily partition (metric_data_daily_2009_feb)
*
ERROR at line 1:
ORA-00376: file 91 cannot be read at this time
ORA-01110: data file 91: '/oradata5/RPTS/cp_report_data25.dbf'

AFTER:
SQL> select count(*) from sgreports.metric_data_daily partition (metric_data_daily_2009_feb)
2 ;

COUNT(*)
----------
0

SQL>
SQL> CREATE TABLE METRIC_DATA_DAILY_FEB as select * from METRIC_DATA_DAILY where 1=0;

Table created.

SQL>
SQL> alter table metric_data_daily exchange partition metric_data_daily_2009_feb with table metric_data_daily_feb;

Table altered.

SQL>

SQL>
SQL> alter table metric_data_daily exchange partition metric_data_daily_2009_mar with table metric_data_daily_mar;

Table altered.

SQL>
SQL>
SQL> alter index sgreports.pk_metric_data_daily rebuild partition METRIC_DATA_DAILY_2009_MAR;

Index altered.

SQL> alter index sgreports.pk_metric_data_daily rebuild partition METRIC_DATA_DAILY_2009_FEB;

Index altered.

SQL>
SQL> spool off
SQL>