thanks everyone.

rt now I have no clue on transportable tablespaces but will be xploring .but yes ,We have pretty clearly marked up tables which can be reconstructed and loaded using scripts anytime and hence need not be backed up every night and those that must be.

[Edited by BRAUK on 12-18-2000 at 03:32 PM]