Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error Ustvarjanje, Dodaj ali Split Oracle Database prekat ne zadostovati s ORA-14080 zmota
Oracle table partitioning is important for optimum performance of the database, as it allows Oracle to process the specific and independat partition or part that is smaller in size, instead of entire full table or database. Oracle tabelo delitev je pomembna za optimalno delovanje baze podatkov, saj omogoča Oracle za obdelavo in posebne independat prekat ali del, ki je manjši, namesto celotne popolne tabele ali baze podatkov. However, when you want to create a new partition to a table by adding or splitting partition, administrator may encounter errors such as Vendar, če želite ustvariti novo particijo na tabelo z dodajanjem ali cepljenju prekat, lahko upravitelj naletijo na napake, kot so ORA-14074 ORA-14074 . . Other than that, Oracle error ORA-14080 can also happen, if you're not careful enough with the following symptom: Razen to, Oracle ORA-14080 napaka se lahko zgodi tudi, če niste dovolj pozorni pri naslednjih simptomov:
ORA-14080: partition cannot be split along the specified high bound ORA-14080: prekat ni mogoče razdeliti ob veže določene visoke
The cause for ORA-14080 error is due to Oracle user attempted to split a partition along a bound which either collates higher than that of the partition to be split or lower than that of a partition immediately preceding the one to be split. Vzrok za ORA-14080 zmota je posledica Oracle uporabniku poskušal razdeliti particije vzdolž vezan, ki se bodisi zbira višja od prekat, ki se razdeli ali nižja od prekat neposredno pred eno, ki se deli. In other word, the value that is been specified to split between the partition is incorrect, and part or all of the range of the partition values has been assigned or located in an existing partition defined in the database. V drugih besedo, vrednost je bila, da je določena v razcep med particija je napačna, in del ali ves razpon particije vrednosti je bila dodeljena, ali se nahajajo v obstoječe particije opredeljeno v bazo podatkov.
To solve the problem, the solution or workaround will be to ensure that the bound along which a partition is to be split collates lower than that of the partition to be split and higher that that of a partition immediately preceding the one to be split. Da bi rešili problem, se bo raztopina ali workaround je, da se zagotovi, da se zavezuje, po katerih je particija, ki se deli zbira nižja od prekat, ki se deli, in da je ta višja od prekat neposredno pred eno, ki se deli. The partition wants to be added or split must has value that are less than its closest higher value partition, yet has value that higher than the upper limit for its closest lower value partition. Partition želi dodati ali razdeliti, morajo vrednost, ki ima manj kot za svoje najbližje višjo vrednost particije, vendar je vrednost, ki presega zgornjo mejo za svoje najbližje nižjo vrednost particije.
For example, 3 partitions existed with high value as below: Na primer, 3 particije obstaja z visoko vrednostjo, kot spodaj:
Partition Name High Value Partition Name High Value
————– ———- ----- ----
p1 20 p1 20
p2 40 p2 40
p3 60 p3 60
If you want to add a new partition by splitting with p3 partition, you cannot specify the value of 70 or 30, as both are out of bound. Če želite dodati novo particijo, da bi delili z p3 prekat, ne morete navesti vrednosti 70 ali 30, saj sta obe iz zavezuje. Specify 30 if you want to split the partition of p3. Določite 30, če želite razdeliti particije za p3. For 70, you have to simply create or add new partition in alter table SQL statement command. Za 70, moraš preprosto ustvariti ali dodati nove particije v tabeli spremeni izjavo SQL ukaz.
Oracle database administrator can use the following command to retrieve a chart like above to help determine the possible wrong value that cause the error: Oracle baze skrbnik, lahko uporabite naslednji ukaz, da prikličete grafikon kot zgoraj, da bi ugotovili morebitne napačno vrednost, ki jo povzroči napaka:
SELECT partition_name, high_value SELECT ime_particije, high_value
FROM dba_tab_partitions IZ dba_tab_partitions
WHERE table_name = 'table_name' KJE ime_tabele = "ime_tabele"
ORDER BY partition_name ORDER BY ime_particije
IMPORTANT : The page is machine translated and provided "as is" without warranty. POMEMBNO: 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 angleški člen whenever possible. kadar je to mogoče.
Related Articles Povezani članki
- Oracle ORA-14074 Create or Add New Partition Fails Error Oracle ORA-14074 Ustvari ali Dodaj nov prekat ne zadostovati zmota
- Oracle Database Import Error 3113/3114 Oracle Database Import Error 3113/3114
- Oracle EXP-00091 Error When Export Database Oracle EXP-00091 zmota čas Export Database
- IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database IMP-00016 Zahtevani Character Set Conversion ne zaslomba zmota čas uvoz v Oracle Database
- Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error Oracle ORA-01658 nezmožen tvoriti PRVA Obseg za segment v Tablespace Napaka
- Oracle Database Link Oracle Database Link
- Change Oracle Database User Password Spremeni Oracle Database Uporabnik Geslo
- ORA-02449 Oracle Drop Table Error ORA-02449 Oracle Drop Table Error
- ORA-00942 Table or View Does Not Exist Oracle Error ORA-00942 tabelo ali si ne obstaja Oracle Error
- View and Retrieve Oracle Database Link Details Ogled in Retrieve Oracle Database Link Details
