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

Hello,

You can change the device sizes also using 'disk resize' command, If you want to access reorg rebuilt command on log part, You can do it.
You have the rule on Sybase like If you have a database like sample with 100GB,In this you have two devices like smapledata with 80GB and samplelog with 20GB,If would like to chang sizes means you can change the sizes of data part and log part.






I hope this will be help for you.




Thanks,
Rajasekhar,
rajasekharreddytadi@gmail.com

Ishu,

You are correct.
Sybase database (data/log) can be expanded but cannot be shrunk.

Not sure how much log.Whatever is allocated to the database already should be good enough to rebuild a table.Did you check what was holding up the log?

Kishor