Visual FoxPro drive index

[ShayLacy]

Stopped working the drive index. What is the procedure ? If it is easy...

Backup - no. Try without a backup.

It would seem not difficult - the index information is recoverable, but something goes wrong.


ALTER DATABASE DATAFILE 'g:\ORACLE\ORADATA\SKONTCO\INDX01.DBF' offline DROP;

and so with all the index files.

Then a vicious circle about primary indexes.

DROP TABLESPACE INDX swears on primary indexes.

Disable constrain primary indexes also impossible... What is the correct order of action?

Thread locked by OP's request -- Programming Moderator Ken g6

 

[ShayLacy]

what do I do? any ideas? I would be grateful for any advice.

 

[oran.mcgee]

The order is:

It is necessary to disconnect tablespace (but not the file as you did)

ALTER TABLESPACE "INDX" OFFLINE;

To mark all indexes in this tablespace as unusable and to reconstruct.

For example:

BEGIN
FOR c_rec IN (SELECT a.index_name
FROM SYS.all_indexes a
WHERE a.owner = 'SUPERMAG' AND a.tablespace_name = 'INDX')
LOOP
BEGIN
EXECUTE IMMEDIATE 'ALTER INDEX ' || t_rec.table_name || ' UNUSABLE';

EXECUTE IMMEDIATE 'ALTER INDEX ' || t_rec.table_name || ' REBUILD TABLESPACE NEW_INDX';
END;
END LOOP;
END;
And then to remove old tablespace.

You can still try to make export and import. While gives the chance - do export.

If nothing helps, you can download foxpro dbf recovery software for .dbf file

Specific software recommendation removed, as spammers often do this. -- Programming Moderator Ken g6