Oracle数据库的创建

create user CQ_TTEST                           --CQ_TTEST为数据库名，也是用户名
  identified by "111111"                             --111111为密码
  default tablespace SYSTEM
  temporary tablespace TEMP
  profile DEFAULT
  password expire
  quota unlimited on SYSTEM
  quota unlimited on SYSTEM
  quota unlimited on users;
-- Grant/Revoke system privileges 
grant alter user to CQ_TTEST with admin option;
grant create any synonym to CQ_TTEST with admin option;
grant create materialized view to CQ_TTEST with admin option;
grant create procedure to CQ_TTEST with admin option;
grant create public synonym to CQ_TTEST with admin option;
grant create sequence to CQ_TTEST with admin option;
grant create session to CQ_TTEST with admin option;
grant create table to CQ_TTEST with admin option;
grant create trigger to CQ_TTEST with admin option;
grant create user to CQ_TTEST with admin option;
grant create view to CQ_TTEST with admin option;
grant drop public synonym to CQ_TTEST with admin option;
grant drop user to CQ_TTEST with admin option;
grant dba to CQ_TTEST;

 

将上面的语句任一一个oracle连接里面的查询中执行（我这里用的是navicat），即可创建数据库。