Before two days i expanded a tablespace creating a new datafile. I used the enterprise manager console.
The problem is that this datafile is indicated as online but no data is written to it. Instead the temporary tablespace is begin using. It's increasing with a huge performance impact.
All of the datafiles permisions are -rw-r--r- and the new datafile has -rw-rw---
Can i change the attributes from the datafile? Do i have to shutdown the database first?
We are using 10g on RedHat Enterprise 4.4