oracle导入dmp示例
1. 启动SQL*Plus
2. 以system/manager登陆
3. create user admin IDENTIFIED BY admin (如果已经创建过用户,这步可以省略)
4. GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO admin
5. 运行-cmd-进入dmp文件所在的目录
E:\>imp userid=admin/admin full=y file=filename.dmp