为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:
【CPU】:
【问题描述】*:
SQL> alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 4096;
alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 4096;
[-2410]:Error in line: 1
Data file [/dmdb8/dmdata/fuwa/fuwa01.dbf] size is invalid.
used time: 0.325(ms). Execute id is 0.
SQL> alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 5120;
alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 5120;
[-2410]:Error in line: 1
Data file [/dmdb8/dmdata/fuwa/fuwa01.dbf] size is invalid.
used time: 0.423(ms). Execute id is 0.
SQL> alter tablespace fuwa datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' autoextend on maxsize 4096;
executed successfully
used time: 7.102(ms). Execute id is 1111.
SQL> alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 1520;
executed successfully
used time: 2.516(ms). Execute id is 1112.
需要先扩展上限值然后再扩展数据文件大小
你当前的版本版本多少,表空间实际使用率是怎样的。正常情况下是可以扩展的。