Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> HELP: imp error

HELP: imp error

From: tracy <tracykim10_at_yahoo.com.hk>
Date: 18 May 2004 00:13:46 -0700
Message-ID: <5c91cce9.0405172313.5fa43638@posting.google.com>


hi, guys,
I really need ur guidance.I just installed oracle db in my backup server(os is linux) and intent to import an .dmp file to it. I had created tablespace, datafiles, users( inclide abc).

Then, i wanna to export an dmp file named test.dmp.so, here is my command:
[root_at_icemsdb root]# su - oracle
bash-2.05$
bash-2.05$ imp fromuser=abc touser=abc file=test.dmp

Import: Release 9.2.0.2.0 - Production on Tue May 18 15:10:08 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Username: system
Password:

IMP-00058: ORACLE error 1033 encountered ORA-01033: ORACLE initialization or shutdown in progressUsername:

what's wrong? Pls help me .

TQ!

regards,
tracy Received on Tue May 18 2004 - 02:13:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US