8i database re-create temporary tablespace datafile
I am running a 8.1.7 database.
I want to resize the datafile in my temporary tablespace.
When I try to resize i get ORA-03297: file contains used date beyond requested resize value.
I have only a single datafile.
Can I drop and re-created temp datafile while users still on the system in 8.1.7
The users have their own tablespace assigned but the temporary tablespace is given access as well as standard temp area.
you create a new one, move all users to it - then when no-one is using the old one you can drop it.
However, it will likely grow to the same size again so why bother changing it?
Instead add a new file to the Temp tablespace ...
Click Here to Expand Forum to Full Width