创建数据库

CREATE TABLESPACE localhost LOGGING DATAFILE \'D:\Oracle\database\localhost.dbf\' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;
create temporary TABLESPACE localhost_temp tempfile \'D:\Oracle\database\localhost_temp.dbf\' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;

CREATE USER username IDENTIFIED BY password DEFAULT TABLESPACE localhost TEMPORARY TABLESPACE localhost_temp;//创建用户
grant connect,resource,dba to username;//给用户添加权限
grant create session to username;

 

 

 

 

 

 

 

删除数据库

conn sys/dwh as sysdba;

drop tablespace localhost including contents and datafiles;

drop tablespace localhost_temp including contents and datafiles;

 

 

 

删除用户

drop user username cascade;

 

版权声明：本文为upsnail原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/upsnail/p/10488567.html