HELP: imp error
From: tracy <tracykim10_at_yahoo.com.hk>
Date: 18 May 2004 00:13:46 -0700
Message-ID: <5c91cce9.0405172313.5fa43638_at_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).
Date: 18 May 2004 00:13:46 -0700
Message-ID: <5c91cce9.0405172313.5fa43638_at_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 - 09:13:46 CEST