Oracle 10g Imp

--

-- $Header: SENTHILKUMARAN.R +919952784002 s9952784002@in.com
-- Copyright (c) Oracle Corporation 1988, 1993.  All Rights Reserved.
--
--
--   This script creates the SQL*Plus demonstration tables.
--
--   It should be STARTed by each user wishing to access the tables.
--
spool D:\11i\Txt\Import_details.txt
set autotrace traceonly

connect system/nip@nip;
select * from tab;

drop user nip cascade;

ALTER SESSION SET NLS_LANGUAGE = AMERICAN;
ALTER SESSION SET NLS_TERRITORY = AMERICA;

CREATE USER NIP IDENTIFIED BY "NIP";

GRANT DBA TO NIP;

connect nip/nip@nip
$imp nip/nip@nip file = 'D:\last_export.dmp' full=y;

select * from tab;
spool off
set autotrace off

select * from tab;