ORA-01122 error

From: Olivier NARTZ <olivier.nartz_at_aipl.uhp-nancy.fr>
Date: Wed, 3 Oct 2001 14:41:56 +0200
Message-ID: <9pf12r$5t8$1@arcturus.ciril.fr>

Hello,

I have a problem :
I have 2 Oracle 8.0.4 Databases (SID PC01 and DICS) running on my server and i made a mistake.
In the DICS DB, I created 3 files for 3 tablespaces (INDX, RBS and TEMP) in then PC01's directory! Of course, the name of these files existed before in this directory!
Connected on DICS, I have run a script to create records. Datas of the USR tablespace aren't corrupted. Now, I have the ORA-01122 error on PC01.

What can i do to recover PC01.

(My databases are not in archivelog mode.)

olivier.nartz_at_aipl.uhp-nancy.fr Received on Wed Oct 03 2001 - 07:41:56 CDT