先看一段官网的说明:14.1.7 Re-creating IndexesYou might want to re-create an index to compact it and minimize fragmented space, or to change the index's storage characteristics. When creating a new index that i
-- 以管理员身份登录PL/SQL, create tablespacecreate tablespace YourProject_table_space datafile 'D:\oracle\data\customed\YourProject.dbf' size 100M;-- create user and assign tablespace for this usercreate