oracle 最简导入导出数据

1、登陆终端

    sqlplus / as sysdba    grant dba to ystr3

2、创建用户，授权

create user lnalims identified by lnalims;grant dba to lnalims;

3、导入数据

    imp user_name/password@ip:orcl file=file_path full=y