Printable View
I am using Sybase ASE 15.0.2
I have loaded a clients database from a dump and it required a 15GB database.
However, when I look at the usage there is only ~350MB of data in there.
Sybase seems to create a file on disk the size of your database despite how much of it is used.
I cant really afford to spare 15GB on my disk.
Is there anyway to resize the database so that it is only 2GB in size?
I would check the SysBase documentation or their web site. If this is common for the product, there has to be some built in way to accomplish what you are after.
You'd think so wouldn't you?
Although, I can't find anything.
I think the next best thing would be to use the bcp command to export all the data out to flat files and create a new database and import them back in.
However, I don't know how to generate the DDL scripts in Sybase to recreate the tables and indexes for the data to go back into :(