Space problem in Index Building

[manish.s]

Hi
I have loaded the DB. Nw Indexbuild is required.
Bt i am getting Insuffecient Disc Space error.

I have lots of space in other parts of the server.
Also Data file and B files area have enough space.
Only problem is i dont have enough space in area where we have files like .st, .db , .lg , .lic.

Can I build the indexes specifying the area name..

Please help me. I cant create the DB again. Its too Big to creat again

 

[Casper]

assuming you get that error during index rebuild:
use the -T parameter to point to where you want the temp-files.

Casper.

 

[manish.s]

proutil <dbname> -C idxbuild -T /dbs/db09/

will this do??

i hv space in /dbs/db09/

n .db file is in some other area.

can u please guide me ??

i dont kw abt -T ..

 

[Casper]

Yes, -T will make that the sort files will be on /dbs/db09 (in this case). You have to make sure that the process is allowed to write there.
And make sure you have enough space.
If you do an idxbuild all then you have to have some 80% (I always use 100% as a guideline ) of the total database size of space in /dbs/db09 if all the tables reside in 1 area.

Casper.

 

[manish.s]

Thanks a lot casper

Ithink it is working..