Oracle 创建本地数据库sql语句

最新推荐文章于 2024-07-04 11:33:52 发布

weixin_30872671

最新推荐文章于 2024-07-04 11:33:52 发布

阅读量3.1k

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/upsnail/p/10488567.html

版权

创建数据库

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;

删除用户