注册

为啥表空间数据文件128M,resize提示大小无效呢

董小姐 2023/10/18 672 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:

[root@localhost ~]# su - dmdba
Last login: Wed Oct 18 08:12:51 CST 2023 on pts/1
Last failed login: Wed Oct 18 08:13:26 CST 2023 on pts/0
There was 1 failed login attempt since the last successful login.
[dmdba@localhost ~]$ source .bash_profile
[dmdba@localhost ~]$ disql sysdba:5237
password:

Server[LOCALHOST:5237]:mode is normal, state is open
login used time : 2.983(ms)
disql V8
SQL> select tablespace_name,file_name from dba_data_files;

LINEID     tablespace_name file_name                    
---------- --------------- -----------------------------
1          fuwa            /dmdb8/dmdata/fuwa/fuwa01.dbf
2          SYSTEM          /dmdb8/dmdata/fuwa/SYSTEM.DBF
3          TEMP            /dmdb8/dmdata/fuwa/TEMP.DBF
4          ROLL            /dmdb8/dmdata/fuwa/ROLL.DBF
5          MAIN            /dmdb8/dmdata/fuwa/MAIN.DBF

used time: 6.629(ms). Execute id is 700.
SQL> select count(*) from fuwa.test_insert;

LINEID     COUNT(*)            
---------- --------------------
1          1000000

used time: 0.479(ms). Execute id is 701.
SQL> alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf to 2048;
2   /
3   ;
SQL> alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 2048;
alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 2048;
[-2410]:Error in line: 1
Data file [/dmdb8/dmdata/fuwa/fuwa01.dbf] size is invalid.
used time: 0.315(ms). Execute id is 0.
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.305(ms). Execute id is 0.
SQL> SELECT tablespace_name,file_name,bytes/1024 total_space,user_bytes/1024 user_space FROM dba_data_files where tablespace_name =FUWA;
SELECT tablespace_name,file_name,bytes/1024 total_space,user_bytes/1024 user_space FROM dba_data_files where tablespace_name =FUWA;
[-2111]:Error in line: 1
Invalid column name [FUWA].
used time: 1.180(ms). Execute id is 0.
SQL> SELECT tablespace_name,file_name,bytes/1024 total_space,user_bytes/1024 user_space FROM dba_data_files where tablespace_name ='FUWA';

LINEID     tablespace_name file_name                     total_space          user_space          
---------- --------------- ----------------------------- -------------------- --------------------
1          fuwa            /dmdb8/dmdata/fuwa/fuwa01.dbf 131072               86528

used time: 10.170(ms). Execute id is 702.
SQL> SELECT tablespace_name,file_name,bytes/1024/1024 total_space,user_bytes/1024/1024 user_space FROM dba_data_files where tablespace_name ='FUWA';

LINEID     tablespace_name file_name                     total_space          user_space          
---------- --------------- ----------------------------- -------------------- --------------------
1          fuwa            /dmdb8/dmdata/fuwa/fuwa01.dbf 128                  84

used time: 8.280(ms). Execute id is 703.


回答 0
暂无回答
扫一扫
联系客服