--创建库 CREATE TABLESPACE TSP DATAFILE ‘/home/oradata/test/test.dbf‘ SIZE 128M AUTOEXTEND ON NEXT 64M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL; -- USER CREATE USER username IDENTIFIED BY password DEFAULT TABLESPACE test; --授权 GRANT RESOURCE,CONNECT TO username;
原文：http://www.cnblogs.com/likanmama/p/4089142.html