Message-ID: <F001.005C7AB6.20030729090434@fatcity.com>
Date: Tue, 29 Jul 2003 09:04:34 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Arup Nanda" <orarup@hotmail.com>
Subject: Re: Please look at this imp command
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Two things to check immediately:

(1) Is the Oracle service defined as started automatically in the services?
(2) If yes, is there any error reported in alert log of the database?

Import does not shut the database down.

HTH

Arup Nanda
----- Original Message ----- 
To: "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent: Tuesday, July 29, 2003 11:04 AM


> imp tpocs/******@tpocs file=c:\Latest_Reference_Files\pharm_jul_2003.dmp
> log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs
> touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608
> 
> Scenario:
> 
> I ran this command (as instructed by the tier III tech), got a couple of
> warnings but it did import 28K plus rows into arc_ndc.  Before I ran the
> command at the command NT command level, I truncated arc_ndc via
> SQL*Plus.
> 
> After the command completed I rebooted the server, there was no
> direction to do this, I just did it for good measure figuring I would
> get a clean oracle instance going.  When the server finished the reboot,
> oracle wasn't up -- or I should say the database wasn't opened.  I had
> to open the database as SYSDBA.
> 
> Did the imp command close the database?  I don't see any directive to do
> so, but being new maybe there is something I don't understand.
> 
> Thanks for your help and patience.
> 
> v/r
> 
> Stephen S. Wolfe, GS-11, DAFC
> Data Services Manager
> stephen.wolfe@macdill.af.mil
> (813) 827-9974  DSN 651-9974
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
>   INET: Stephen.Wolfe@macdill.af.mil
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup@hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).