can somebody pl. help me to sort the problem of recovery.
Database was set up by earlier DBA working here, and i dont have much cuel about the same.
Details of Database on Window NT
Oracle8i Release 188.8.131.52.0 - Production
PL/SQL Release 184.108.40.206.0 - Production
CORE Version 220.127.116.11.0 - Production
TNS for 32-bit Windows: Version 18.104.22.168.0 - Production
NLSRTL Version 22.214.171.124.0 - Production
Have database backup in Archieve mode on
And Following is details related to datafile of Temp tablespace
THis datafile has grown over the days nobody know why and since when?
RECOVER READ WRITE
And as this datafile need to be recovered, and is not online
we cant make any modification and if we try to compile anything in production it fails.
Can somebody help me and tell me what do i need to do for getting this data file online, i know i need to use Recovery manager but can someone take me thru the steps to do the same
Hoping that somebody will reply .
you can change you users to use another tablespace for there temporary segments.
This does not resolve you problem, but your users can work again.
alter user <ausername> temporary tablespace <anotherTS>;
temporary tablespace shouldnt be tricky, create another temporary tablespace and alter all users to use that new temporary tablespace, then you can drop the faulty temporary tablespace
Click Here to Expand Forum to Full Width