You are not logged in or registered. Please login or register to use the full functionality of this SYBASETEAM.COM Website...
Current time: 03-11-2010, 10:34 AM Hello There, Guest! (LoginRegister)
Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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
Find all posts by this user
Quote this message in a reply

Post Reply 


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

Forum Jump: