> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# admin_repair_table

<div className="kinetica-pydoc">
  <div className="dl py method">
    <div className="dt sig sig-object py" id="gpudb.GPUdb.admin_repair_table"> <span className="sig-name descname"><span className="pre">admin\_repair\_table</span></span><span className="sig-paren">(</span><span className="em sig-param"><span className="n"><span className="pre">table\_names</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">table\_types</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">options</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">{"{"}{"}"}</span></span></span><span className="sig-paren">)</span><a href="https://github.com/kineticadb/kinetica-api-python/blob/master/gpudb/gpudb.py#L15089"><span className="viewcode-link"><span className="pre">\[source]</span></span></a></div>

    <div className="dd">
      <p>Manually repair a corrupted table. Returns information about affected tables.</p>
      <p><strong>Parameters</strong></p>

      <div className="blockquote">
        <div>
          <div className="dl">
            <div className="dt">table\_names (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of tables to query. An asterisk returns all tables. The user can provide a single element (which will be automatically promoted to a list internally) or a list.</p>
            </div>

            <div className="dt">table\_types (<span className="em">dict of str to str</span>) –</div>

            <div className="dd">
              <p>ID of the type per table.</p>
            </div>

            <div className="dt">options (<span className="em">dict of str to str</span>) –</div>

            <div className="dd">
              <p>Optional parameters. Allowed keys are:</p>

              <ul>
                <li>
                  <p><strong>repair\_policy</strong> – Corrective action to take. Allowed values are:</p>

                  <ul className="simple">
                    <li>
                      <p><strong>delete\_chunks</strong> – Deletes any corrupted chunks.</p>
                    </li>

                    <li>
                      <p><strong>shrink\_columns</strong> – Shrinks corrupted chunks to the shortest column.</p>
                    </li>

                    <li>
                      <p><strong>replay\_wal</strong> – Manually invokes write-ahead log (WAL) replay on the table.</p>
                    </li>

                    <li>
                      <p><strong>alter\_table</strong> – Reset columns modification after incomplete alter column.</p>
                    </li>
                  </ul>
                </li>

                <li>
                  <p><strong>verify\_all</strong> – If <span className="em">false</span> only table chunk data already known to be corrupted will be repaired. Otherwise the database will perform a full table scan to check for correctness. Allowed values are:</p>

                  <ul className="simple">
                    <li>
                      <p>true</p>
                    </li>

                    <li>
                      <p>false</p>
                    </li>
                  </ul>

                  <p>The default value is ‘false’.</p>
                </li>
              </ul>

              <p>The default value is an empty dict ( {"{"}{"}"} ).</p>
            </div>
          </div>
        </div>
      </div>

      <p><strong>Returns</strong></p>

      <div className="blockquote">
        <div>
          <p>A dict with the following entries–</p>

          <div className="dl simple">
            <div className="dt">table\_names (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of repaired tables.</p>
            </div>

            <div className="dt">repair\_status (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>List of repair status by table.</p>
            </div>

            <div className="dt">info (<span className="em">dict of str to str</span>) –</div>

            <div className="dd">
              <p>Additional information.</p>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
