February 11, 2015 at 3:23 am
Visual FoxPro. The disk with indexes was damaged. What operations procedure? If it is easy...
Backup - No. I try without backup.
It would seem not difficult - information of indexes can be restored, but something goes wrong.
ALTER DATABASE DATAFILE 'g:\ORACLE\ORADATA\SKONTCO\INDX01.DBF' offline DROP;
And so with all the indexes files.
Further vicious circle regarding primary indexes.
DROP TABLESPACE INDX swear on primary indexes.
Disable constrains primary indexes too impossible...
What correct operations procedure?
February 11, 2015 at 7:29 am
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 have to restore the file .dbf through DBF Viewer Tool. http://www.dbf.viewertool.com/[/url]
Just in case go to this forum and look at the topic
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply