Create an oracle database

-- Create a data table space
Create tablespace mytablespace
Datafile 'd:/mytablespace. dbf'
Size 32 m
Autoextend on
Maxsize unlimited;

-- Create temporary tablespace
Create temporary tablespace temptablespace
Tempfile 'd:/mytempspace. ldf'
Size 32 m
Autoextend on
Maxsize unlimited;

-- Delete data table space and temporary tablespace
Drop tablespace mytablespace including contents and datafiles;
Drop tablespace temptablespace including contents and datafiles;

-- Create a user for the tablespace
Create user my identified by Hilbert default tablespace mytablespace temporary
Tablespace temptablespace;

-- Authorization and Revocation
Grant connect, resource to my;
Revoke connect, resource from my;

-- Change User Password
Alter user my identified by www;

-- Delete users and all modes
Drop user my cascade;

This article is from the "to simplicity" blog, please be sure to keep this source http://zhijian.blog.51cto.com/2057586/1298560