Oracle新建用户
登陆数据库sys/manager as sysdba
create user test identified by test; //创建用户名为test的帐号,密码为test。
Grant create session to test; //授权test用户登录权限。
创建名为“SXSJ”的表空间,其初始大小为512M,支持自动扩展,每次增量为32M;
create tablespace SXSJ datafile 'D:\app\LZB\oradata\SXSJ' size 512M autoextend on next 32M;
创建名为“SXSJ”的用户
CREATE USER META_BDP IDENTIFIED BY SXSJ DEFAULT TABLESPACE SXSJ;
为“SXSJ”用户授权SXSJ为用户密码·
GRANT RESOURCE,DBA,CONNECT TO SXSJ;
导入DMP文件
imp V_BDP/V_BDP@orcl file=C:\Users\XiaoYu\Desktop\bdp.dmp full=y ignore=y;
解锁用户
alter user 用户名 account unlock