Oracle 创建本地数据库sql语句

CREATE TABLESPACE localhost LOGGING DATAFILE ‘D:Oracledatabaselocalhost.dbf‘ SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;

create temporary TABLESPACE localhost_temp tempfile ‘D:Oracledatabaselocalhost_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;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!