21、alter tablespace .. rename datafile ...

alter tablespace .. rename datafile ...

而不是alter database ..rename datafile...

drop掉一个datafile的方法

[@more@]

1、alter database .. rename datafile.. is syntactically incorrect.The RENAME DATAFILE clause is not a valid clause of the ALTER DATABASE statement.

2、drop datafile

Take the datafile offinle by using the ALTER DATABASE ...DATAFILE..OFFLINE statement,and drop the datafile by using ALTER DATABASE...DROP DATAFILE statement.

The DROP DATAFILE clause is not valid for the ALTER TABLESPACE statement

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/248644/viewspace-933064/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/248644/viewspace-933064/