drop tablespace problem

[liu liu]

sELECT LOGFILE_GROUP_NAME, FILE_NAME, EXTRA FROM INFORMATION_SCHEMA.FILES ;
+--------------------+------------------+-----------------------------------------+
| LOGFILE_GROUP_NAME | FILE_NAME | EXTRA |
+--------------------+------------------+-----------------------------------------+
| LGGP1_NDB | zctt_file01.dbf | CLUSTER_NODE=5 |
| LGGP1_NDB | zctt_file01.dbf | CLUSTER_NODE=6 |
| LGGP1_NDB | zctt_file01.dbf | CLUSTER_NODE=7 |
| LGGP1_NDB | zctt_file01.dbf | CLUSTER_NODE=8 |
| LGGP1_NDB | NULL | NULL |
| LGGP1_NDB | NDB_UNDO_01.dbf | CLUSTER_NODE=5;UNDO_BUFFER_SIZE=8388608 |
| LGGP1_NDB | NDB_UNDO_01.dbf | CLUSTER_NODE=6;UNDO_BUFFER_SIZE=8388608 |
| LGGP1_NDB | NDB_UNDO_01.dbf | CLUSTER_NODE=7;UNDO_BUFFER_SIZE=8388608 |
| LGGP1_NDB | NDB_UNDO_01.dbf | CLUSTER_NODE=8;UNDO_BUFFER_SIZE=8388608 |
| LGGP1_NDB | NDB_UNDO_02.dbf | CLUSTER_NODE=5;UNDO_BUFFER_SIZE=8388608 |
| LGGP1_NDB | NDB_UNDO_02.dbf | CLUSTER_NODE=6;UNDO_BUFFER_SIZE=8388608 |
| LGGP1_NDB | NDB_UNDO_02.dbf | CLUSTER_NODE=7;UNDO_BUFFER_SIZE=8388608 |
| LGGP1_NDB | NDB_UNDO_02.dbf | CLUSTER_NODE=8;UNDO_BUFFER_SIZE=8388608 |
| LGGP1_NDB | NULL | UNDO_BUFFER_SIZE=8388608 |
+--------------------+------------------+-----------------------------------------+

SELECT TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE";
+-----------------+------------------+---------------+---------------+----------------+
| TABLESPACE_NAME | FILE_NAME | TOTAL_MB | FREE_MB | EXTRA |
+-----------------+------------------+---------------+---------------+----------------+
| zctt_tablespace | zctt_file01.dbf | 8192.00000000 | 8192.00000000 | CLUSTER_NODE=5 |
| zctt_tablespace | zctt_file01.dbf | 8192.00000000 | 8192.00000000 | CLUSTER_NODE=6 |
| zctt_tablespace | zctt_file01.dbf | 8192.00000000 | 8192.00000000 | CLUSTER_NODE=7 |
| zctt_tablespace | zctt_file01.dbf | 8192.00000000 | 8192.00000000 | CLUSTER_NODE=8 |
+-----------------+------------------+---------------+---------------+----------------+

mysql> alter tablespace zctt_tablespace drop datafile 'zctt_file01.dbf';
ERROR 1533 (HY000): Failed to alter: NO SUCH FILE