– 创建表空间 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;
在数据导入完成后，使用每个用户，将该用户下的对象全部编译。
