Untested, here's a suggestion:
- Change SYS and SYSTEM to use SYSTEM tablespace as the temp
tablespace -- if it lets you, I'm not sure.
- drop tablespace TEMP
- alter database open
- recreate TEMP tablespace
Cyril Caillaud wrote in message <82qt32$88t$1_at_jaydee.iway.fr>...
>Hi
>
>I use Oracle 8.0.4 on windows NT 4.0 and i have a problem
>
>When i try to open the database i have somes errors
>
>ORA - 01122 database file 4 failed verification check
>ORA - 01110 data file tmpprojet.ora
>ORA - 01200 actual size of 1048361 is smaller than correct size of 1048501
>blocks
>
>the datafile is tmpprojet.ora, it's the temporary datafile
>
>I have no problem to mount the database but i can't open it.
>
>Can someone have a idea to open the database ?
>if l lost the datafile it's not a problem.
>
>
>Thanks
>
>Cyril Caillaud
>
>
Received on Tue Dec 14 1999 - 23:58:42 CST
