Dmitry:
It looks like you are trying to build the tablespace a second time and that is why you are getting the error.
Can you try this:
Create the database with no other users than are created by the Oracle install and then run IMP to bring in the database. This should restore the ARSYSTEM tablespace and the ARADMIN user.
James McKenzie
L-3 GSI
________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Bezhenar, Dmitry
Sent: Thursday, September 14, 2006 9:38 AM
To: [email protected]
Subject: Re: Oracle question
**
Hi James,
I've just installed a new clear Oracle, created Aradmin user in it (see KM-000000006831), created "Arsystem" tablespace and now I am trying to import this full_blabla.dmp file.
Kind Regards
Dmitry Bezhenar
________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Thursday, September 14, 2006 8:17 PM
To: [email protected]
Subject: Re: Oracle question
**
Dmitry:
Are you attempting to import to an existing database or a brand new one?
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Bezhenar, Dmitry
Sent: Thursday, September 14, 2006 9:15 AM
To: [email protected]
Subject: OT: Oracle question
Hello List,
I am a newbie in Oracle and I have some problems with importing a full database dump.
During the import process I receive the following errors -
IMP-00041: Warning: object created with compilation warnings (many times)
IMP-00017: following statement failed with ORACLE error 12154:
....
IMP-00003: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name (twice)
Thank you.
PS: The import command is the following Imp system/*** file=*** full=y log=***
Kind Regards
Dmitry Bezhenar
