ORA-39309: Cannot alter tablespace between bigfile and smallfile.

ORA-39309: Cannot alter tablespace between bigfile and smallfile.
Cause: DBMS_METADATA_DIFF was comparing two tablespaces, one bigfile, one smallfile. There is no SQL ALTER statement to change a tablespace from smallfile to bigfile or vice versa.
Action: The difference cannot be eliminated with an SQL ALTER statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:52

ORA-39309：不能在bigfile和smallfile之间更改表空间。,
.原因： DBMS_METADATA_DIFF正在比较两个表空间，一个bigfile，一个smallfile。没有SQL ALTER语句将表空间从smallfile更改为bigfile，反之亦然。,
.操作：使用SQL ALTER语句无法消除该差异。,
.

aiaiDBA

13718043309

010-86462881

ORA-39309: Cannot alter tablespace between bigfile and smallfile.

1 个回答

相似问题