Re: ORA-01122 error

"Bonjour" from Paris,

I don't think so there is a lot of solutions. In no archive mode, no solutions : i think your tablespace are lost.

Export if you can the contents of the INDX tablespace (exp with index file) in order to re-create
the index later. Verify the indexes relative to referentiel key .... Remove the rbs information in the int.ora relative to the tbs RBS.

And do the following for all the tbs in all the databases :

SVRMGRL> alter database datafile '<file name and path>' offline drop;

                for each tbs.
 SVRMGRL> alter database open;
  SVRMGRL> drop tablespace <tablespace name> including contents;

And recreate the right tbs and import the index ....

"Au revoir" from Paris

Hieraklion

Olivier NARTZ wrote:

>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 - 11:56:51 CDT