|
-
thanks Jeff.
Most of the tablespaces are for partitioned tables(6 tables , 45 partitions each). Data in these tables will become readonly after 3 days and on 46th day will be deleted totally. The activity in these tables will be very heavy insertions on the first day and done using loader. In case something goes wrong, we have the data and need to reload again.
But for one table this is not so. Its going to be a table with less deletes, but insertions and updates will be there.I am keeping this on a separate tablespace, so that it can be maintained separately.
Thanks for your suggestions, I guess there is really no other way than what you have suggested.
manjunath
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|