完全删除一个老的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-删除及创建新用户及表空间完全删除一个老的user及表空间创建新的user及表空间所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。