Oracle Database Discussions

I noticed that a table was causing problems in ou systems because it was growing all the time. After I performed a shrink, this table was only half the size and the problem was resolved.

To prevent this to occur with other tables, I' m planning to set up a weekly "shrink job", that shrinks ALL the tables. What do you think about that? Are there any objections to shrink all the tables or should you always only shrink the tables which are growing and have a lot of free space?

I'm aware of the fact that during the shrinking the corresponding tables are locked and can not been accessed, but this can be ignored in our system as we do the shrinking at night and then there are no users working.

Thanks for you replies.