本机安装oracle建表

sqlplus system/orcl  登录系统用户

create user test identified by test; 创建test/test用户

grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to test;  给test用户赋权限

exit;

imp system/orcl@orcl file="E:\zero\ptdemo.dmp"
imp test/test file="E:\zero\ptdemo.dmp" full=y  把脚步导入到test用户下面