Create User

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Jan 31 20:01:48 2014

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

connect system/nip@nip

drop user nip cascade;

create user nip identified by "nip";

grant dba to nip;

connect nip/nip@nip

$imp nip/nip@nip file = 'd:\11i\last_export.dmp' log = 'c:\new_install_error.txt' full=y;

select * from tab;