hunchback
asked on
How to delete/remove rollback files?
i cannot delete a very large table because when doing so - it actually needed more space to write records to the rollback file. So now the HardDisk is filled to the brink..
How can i delete the rollback file - i tried to substitute it with a zero byte file of the same name but Oracle won't be fooled.
How can i delete the rollback file - i tried to substitute it with a zero byte file of the same name but Oracle won't be fooled.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Perhaps it is worth adding that if you issue a truncate statement that it will
1. Delete all records
2. Happen immediately
3. It is 'un-rollbackable'. i.e. you cannot then rollback the transaction should you want to. Truncate bypasses a large part of the Oracle dataserver and hence you cannot rollback should you realise you have made an error.
Use it with caution.
If you dont want to delete the whole table and hence want to delete certain rows then consider my original answer of either breaking the delete down into logical steps or increasing the rollback segment by adding a new datafile.
Do you have another disk on this system with space?
you can simply truncate table.
(e.g. truncate table my_table)
i hope it solves your current problem.
hakang