1、cd $ORACLE_HOME/network/admin/
将sqlnet.ora改个名字
2、用sys用户登录
sqlplus '/as sysdba'
查看用户
select username,account_status from dba_users where account_status='OPEN';
修改用户的密码
password username;(或alter user username IDENTIFIED BY password; )
3、或者创建个和导出时一样的tablespace和user,并赋予导入权限
create tablespace ts01 datafile '/data1/oracle/test_201203.dbf' size 2048M AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED;
create user user01 identified by password1 default tablespace ts01;
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 user01;
4、imp user01/password1 file=your.dmp FULL=y log=imp.log
