完全删除一个老的user及表空间

DROP USER username CASCADE;
DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;
# DROP TABLESPACE tablespace_name;
alter database datafile 'v$datafile/tablespace_name.dbf' offline drop;

创建新的user及表空间

CREATE TABLESPACE username DATAFILE 'v$datafile/tablespace_name.dbf' SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE 10240M EXTENT MANAGEMENT LOCAL;
CREATE USER username IDENTIFIED BY passwd DEFAULT TABLESPACE tablespace_name;
grant connect,resource to username;
grant unlimited tablespace to username;
grant create database link to username;
grant select any sequence,create materialized view to username;

备注：
ORA-00950: invalid DROP option
ORA-02142: missing or invalid ALTER TABLESPACE option
ORA-01543: tablespace ‘tablespace_name’ already exists
ORA-01109: database not open
ORA-01516: nonexistent log file, data file, or temporary file
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01116: error in opening database file 8
ORA-01110: data file 8: ‘tablespace_name.dbf’
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

最后

以上就是内向巨人最近收集整理的关于ORACLE-删除及创建新用户及表空间完全删除一个老的user及表空间创建新的user及表空间的全部内容，更多相关ORACLE-删除及创建新用户及表空间完全删除一个老内容请搜索靠谱客的其他文章。