//分配表空间
create tablespace protal logging datafile 'D:\app\sun_hguo\oradata\portal\portal.dbf' size
100m autoextend on next 32m maxsize 2048m extent management local;
//创建用户
create user portal identified by portal default tablespace protal;
//授权
grant connect,resource,dba to portal;
//导入
imp portal/portal@zz file=D:\swsflow_20120416.dmp full=y ignore=y;
建用户:
create user 用户名 identified by 密码 default tablespace 默认表空间 temporary 临时表空间;
赋权限:
grant connect,resource,
create any view,
create any synonym,
create database link,
select any table,
create table,
update any table,
insert any table,
delete any table,
alter any table
to 用户名;
选择就可以了
创建序列.
CREATE SEQUENCE HIBERNATE_SEQUENCE MINVALUE 0 MAXVALUE 999999999999999999999999;