ORA-01502 Oracle Index in Unusable State ORA-01502 Oracle Kazalo neuporabni v državni

When trying to perform query on Oracle tables with select SQL statement, Oracle returns the following error: Ko poskušate izvesti poizvedbo na Oracle tabele izberite z izjavo SQL, Oracle vrne naslednje napake:

ORA-01502: index 'string.string' or partition of such index is in unusable state ORA-01502: indeks "string.string ali particiji takega indeksa je v neuporabno stanje

The error indicates an attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation. Napaka kaže poskus je bil narejen za dostop do indeksa ali indeksa particije, ki je bil označen kot neuporabni, z neposredno obremenitvijo ali s DDL delovanje.

The problem usually happens when using the Direct Path for the SQL*Loader, Direct Load or DDL operations. Težava ponavadi zgodi, ko z uporabo Direct Pot za SQL * Loader, Direct Load ali DDL operacij. This requires enough temporary space to build all indexes of the table. To zahteva začasno dovolj prostora za izgradnjo vseh indeksov v tabeli. If there is no enough space in TEMP tablespace, all rows will still be loaded and imported, but the indices are left with STATUS = 'INVALID'. Če ni dovolj prostora na TEMP tablespace vse vrstice, bo še vedno naložen in uvožene, vendar indeksi so imeli status = "INVALID".

Invalid indexes can be checked with a SELECT * from USER_INDEXES WHERE STATUS = 'INVALID'; SQL statement. Neveljavni indeksi se lahko preverijo z SELECT * od USER_INDEXES KJE STATUS = "INVALID"; SQL izjavo.

Solution to this error is simple. Rešitev za to napako je preprost. You can: Lahko:

1. Drop the specified index and/or recreate the index Odvrzi določeni indeks, in / ali ponovno indeks
2. Rebuild the specified index Obnovitev določenega indeksa
3. Rebuild the unusable index partition Obnovo neuporabno indeks particijo

Generally, the following SQL manipulation language will be able to rebuild the unusable index: Na splošno se po SQL jezik za manipulacijo bodo sposobni za obnovo neuporabno indeks:

ALTER INDEX index_name Alter KAZALO index_name REBUILD Obnovitev

IMPORTANT : The page is machine translated and provided "as is" without warranty. POMEMBNO: Ta stran je stroj prevod in če "kot je" brez garancije. Machine translation may be difficult to understand. Strojno prevajanje je lahko težko razumeti. Please refer to Prosimo, da original English article original English članek whenever possible. kadar je to mogoče.

Related Articles Sorodni članki

• Oracle ORA-14074 Create or Add New Partition Fails Error Oracle ORA-14074 Ustvari Dodaj novo particijo ali ne Napaka
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error Ustvari, Dodaj ali Split Oracle Database particije ne z ORA-14080 Napaka
• How to Escape Characters in Oracle PL/SQL Queries Kako Escape Znaki v Oracle PL / SQL Queries
• ORA-02449 Oracle Drop Table Error ORA-02449 Oracle Drop Tabela Napaka
• Check Oracle Version Preverite Oracle Version
• ORA-00942 Table or View Does Not Exist Oracle Error ORA-00942 Tabela ali pogled ne obstaja Oracle Napaka
• Oracle Database Import Error 3113/3114 Oracle Database Import Error 3113/3114
• Oracle PL/SQL ORA-00947 Not Enough Values Error Oracle PL / SQL ORA-00947 Ni dovolj Vrednosti Napaka
• Oracle JDeveloper Reviews Oracle JDeveloper Reviews
• Manual and Clean Uninstall Oracle for Windows Ročno in čistega Odstrani Oracle za Windows

This entry was posted on Saturday, January 28th, 2006 at 4:07 pm and is filed under Ta vnos je bil objavljen na sobota, 28. januar 2006 ob 4:07 in je vložena v skladu s Databases Podatkovne baze . . You can follow any responses to this entry through the Lahko sledenje vseh odzivov na to vstop skozi RSS 2.0 RSS 2.0 feed. You can krme. Lahko leave a response pustite odgovor , or , Ali trackback Sledilnik from your own site. iz vaše strani.