delete rows and shrink space
chijarJun 25 2009 — edited Jul 16 2009dear all.
I have a schema with 24 tables that contains millions of rows. Only pk constraint exists in each table. Not exists FK.
My database is short of space and that is the reason for delete rows.
Well.. i want to delete rows (based in a criteria) from each tables and that table have miles or millions of rows and then i want to shrink tablespace and/or segments in order to RESIZE my datafiles and recover space in my server.
question:
1.- What is the best method in order recover space after i deleted rows ????
2.- If you have a fast method to delete rows without generate UNDO. what is?
facts:
- oracle 10g r2.
- rhel
- is a test database. Only i stay connected.
thanks a lot for your answers.