|
log space requirements for reorg rebuild
|
|
05-27-2009, 01:29 PM
Post: #1
|
|||
|
|||
|
log space requirements for reorg rebuild
Hi all
I want to know how much log space is required to rebuild a table. For example if I have a table of 10 GB then to run reorg rebuld on this table how much log space is required.(i guess 120% of data space is required for reorg rebuild a table) And if my log space is not sufficient then is it possible to add some log device temporarily and remove it later from the database(which i guess is not possible in Sybase. What I know is that we can only add space to a database using alter database, but can't reduce it anyhow, Please correct me if I am wrong). Please help me out. Regards Ishu Srivastava |
|||
|
« Next Oldest | Next Newest »
|
| Possibly Related Threads... | |||||
| Thread: | Author | Replies: | Views: | Last Post | |
| Sybase Database dump failed for a database with no space left on device error | padalav | 0 | 172 |
01-28-2010 10:37 AM Last Post: padalav |
|
| Determining Free Log Space in Sybase ASE | Joshi | 0 | 254 |
12-04-2009 09:47 PM Last Post: Joshi |
|
| running reorg in sybase - reorg command usage | zaadmin | 0 | 225 |
06-19-2009 03:07 AM Last Post: zaadmin |
|
| monitor sybase tempdb log space | albert | 0 | 782 |
04-22-2009 01:58 AM Last Post: albert |
|
| Sybase Tempdb space management and addressing tempdb log full issues | zaadmin | 0 | 2,750 |
11-10-2008 10:25 PM Last Post: zaadmin |
|

Chat Support
Search
Disclamier & Rules
Help


