cancel
Showing results for 
Search instead for 
Did you mean: 

How to reduce sapdata_1 file size in SAP

Former Member
0 Kudos

Hi All,

We have installed sap on sybase 15.0.121 on windows ,at the time of installation by mistake we given sapdata_1 file Initial size 300GB

Now i want to reduce the sapdata_1 file to 120GB as drive is showing full.

Please explain how can i reduce

Please explain step by step.

Regards

Chandra

Accepted Solutions (0)

Answers (1)

Answers (1)

srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Chandhra,

You can check Table space size.

What are table spaces pointed this data file.

If that table not filled 100%, than you can think to alter the tables spaces.

Former Member
0 Kudos

Hi Srnivasan,

There is no table space concept in sybase.sap data will stored directly in .dat files.

Could you please tell how can i reduce datafile size in sybase

Regards

Chandra