Oracle创建表空间用户

– 创建表空间
create tablespace portal datafile ‘&1\portal.dbf’ size 100m autoextend on next 10m;

– 删除表空间
drop tablespace portal including contents;

– 创建用户
create user portal identified by portal default tablespace portal;

–赋权限
grant dba to portal;
grant all on dual to portal with grant option;
grant create any table to portal;

– 导入dmp文件
imp portal/store@192.168.1.130/agent file=d:\portal.dmp log=d:\portal170704.log fromuser=portal touser=portal

– 导出dmp文件
exp portal/store@192.168.1.130/agent file=d:\portal.dmp log=d:\portal170704.log owner=portal

– 修改用户密码
alter user portal identified by Gzgs377;

在数据导入完成后，使用每个用户，将该用户下的对象全部编译。