如何删除表空间
1.用system登录数据库
2.--然后删除表空间
DROP TABLESPACE testDatabase INCLUDING CONTENTS;
3.--然后删除数据文件
/usr/local/ora8i/oradata/orcl 下面的相应的 ".dbf"文件
4.--然后删除用户
DROP USER nmstest CASCADE;
如果直接删除".dbf"文件将导致数据库异常,恢复方法:
1. 用oracle用户进入/usr/local/ora8i/bin
2. ./svrmgr
3. connect internal
4. select name from v$datafile;
5. 可以找到刚才被删除的那个文件,包括它的路径:/usr/local/ora8i/oradata/orcl/testDatabase.dbf
6. alter database datafile '/usr/local/ora8i/oradata/orcl/testDatabase.dbf' offline drop;
会看到提示:Database altered 就可以了
--创建TssWeb表空间
CREATE TABLESPACE HdccDatabase DATAFILE '/opt/oracle/oradata/orcl/HdccDatabase.dbf' SIZE 50M;
CREATE USER hdcc IDENTIFIED BY hdcc DEFAULT TABLESPACE HdccDatabase TEMPORARY TABLESPACE temp;
GRANT connect,resource TO hdcc;
grant create any library to hdcc;
--change datafile size
alter database datafile '/opt/oracle/oradata/orcl/HdccDatabase.dbf' autoextend on next 50M maxsize 9500M;