How to get the available space in the a directory

[Ramakanta Sahoo]

Hi All,

I'm not able to find the query which will retun the available space in the a directory in the host machine where we are goin to create a dbf file.

Please help!!

[Jeanne Boyarsky]

Why would you have a space limit by directory? I would think this would be on a machine basis. Or do you mean a tablespace?

[Ramakanta Sahoo]

Jeanne Boyarsky wrote:Why would you have a space limit by directory? I would think this would be on a machine basis. Or do you mean a tablespace?

i am creating a DB installer which will query the space availble in the drive before creating the index tablespace and data tablespace.
As my table spaces are huge like 3GB startup size. I want to query the space available in the drive where the user will put his tablespaces. If space is not more than 5GB it will throw a warning message "Drive Free Space is below 5GB, You may face problems during data seeding"

[Jeanne Boyarsky]

I see. It's the drive space; not the directory space.

The way to get that would be an operating system command. In Java, you would call Runtime.exec() to issue one. In Oracle, you would use this.