ccmdb repair database_path -i|-repair_index table_name|index_name|"" [-y] ccmdb repair database_path -t|-repair_table table_name [-y]
Use the ccmdb repair command to repair indexes and tables corrupted at the database level.
For more information, see Repairing databases
To run this command, you must log on as the Oracle user who has write privileges for the appropriate tasks. For more information, see Setting up user privileges for Oracle.
database_path
Specifies the path to the database you are repairing.
-i|-repair_index table_name|index_name|""
Indicates that you want to re-create an index. If -repair_index is specified with a table name, all the indexes in the table are repaired. If an index name is specified, only the specified index is repaired. If "" is specified, all indexes in the database are repaired.
The possible tables are as follows: acckeys, attrib, bind, bsite, compver, control, relate, and release.
-t|-repair_table table_name
Indicates that you want to repair table data for table_name. To repair table data, rename the table, create the table, copy to the new table, and then delete the old table.
-y
Executes the command without displaying confirmation messages.