oracle创建数据库

--创建文件
create tablespace mydb logging datafile 'F:\Oracle\mydb.dbf'
size 100m autoextend on next 32m maxsize 500m extent management local;

create temporary tablespace mydb_temp tempfile 'F:\Oracle\mydb_temp.dbf'
size 100m autoextend on next 32m maxsize 500m extent management local;

--创建用户和数据库映射
create user myuser identified by 123456 default tablespace mydb temporary tablespace mydb_temp;

--授权
grant connect,resource,dba to myuser;
--允许用户登录
grant create session to myuser;

--删除表
--drop tablespace mydb including contents and datafiles

--删除用户
--drop user myuser cascade

连接成功