Consultor Eletrônico



Kbase P86341: Unable to prostrct remove area - errors 8565 6961
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   04/01/2006
Status: Verified

SYMPTOM(s):

Storage area has been truncated to the first extent

All the database objects have been deleted from this area through Database dictionary

The Storage Area is not the Schema Area

Unable to prostrct remove that area - errors 8565 6961

The last extent of area <area name> is in use. (8565)

Extent delete rejected. (6961)

CAUSE:

A regression issue introduced sometime after 9.1D FCS

FIX:

It is sufficient to repeat the truncate area, for prostrct remove to work:

Steps:

1.) Re-truncate area:
$ proutil dbname -C truncate area [area-name] -G 0

2.) Truncate bi:
$ proutil dbname -C truncate bi -G 0

3.) Prostrct remove the area:
$ prostrct remove dbname d [area-name]