Hi guys,

how do i reset size of data file.currently for example temp and undo tablspace have lot of data files around 7 files each , where the utilization is very minimal.

Some other tablespace don't have any space left.the Drive on which all these tablespace are also full.the only option left for me resize couple of data files on various table spaces and assign this to the required ones.

when i try to resize it gives me an error, there is data in this you cannot resize .

if we resize will be there be any chance of DB crash or data lost, the reason asking is, it's production.

Pls help.