ORA-02449 Oracle óôáãüíá ôñáðÝæé Error
ìåñéêÝs öïñÝs ðüôå dropping Ýíás ôñáðÝæé ìÝóá Oracle âÜóç äåäïìÝíùí áðü åêôåëþíôáò óôáãüíá ôñáðÝæé SQL äÞëùóç, Oracle ìðïñþ åðéóôñïöÞ the error ORA-02449 üðùò õðü:
ORA-02449: ìïíáäéêüò/ âáóéêüò êëåéäéÜ ìÝóá ôñáðÝæé ðáñáðïìðÞ áðü áëëïäáðüò êëåéäéÜ
The Oracle error is ðñïêÜëåóá ìå ôï ðáñáêïëïõèþ óå óôáãüíá Ýíás ôñáðÝæé ìå ìïíáäéêüò Þ âáóéêüò êëåéäéÜ ðáñáðïìðÞ áðü áëëïäáðüò êëåéäéÜ ìÝóá another ôñáðÝæé, Þ ìÝóá Üëëïò ëÝîç, the ôñáðÝæé áõôü åßíáé üëï ðáñáðïìðÞ üðùò Ýíás ãïíéüs ôñáðÝæé áðü Ýíás áëëïäáðüò êëåéäß constraint ìÝóá Ýíás ãïíéüs- ðáéäß ó÷Ýóç üôé ßäñõóá áíÜìåóá äýï ôñáðÝæé äéáìÝóïõ Ýíás áëëïäáðüò êëåéäß. Oracle does ü÷é åðéôñÝðù ðåôÜãïìáé ôñáðÝæé ðáñáðïìðÞ áðü áëëïäáðüò êëåéäéÜ áðü Üëëïí ôñáðÝæé ÷ùñßs êáèïñéóôéêüò the CASCADE CONSTRAINTS ðñïáßñåóç ìÝóá óôï óôáãüíá ôñáðÝæé äÞëùóç, Þ ðåôÜãïìáé the ãïíéüs ôñáðÝæé ÷ùñßs ðñþôïò ìåôáêüìéóç the áëëïäáðüò êëåéäß.
The ëýóç êáé workaround ãéá the error ðüôå you èÝëù ðåôÜãïìáé ôñáðÝæé ðáñáðïìðÞ áðü ðáéäß ôñáðÝæé, is óå ÷ñÞóç the CASCADE CONSTRAINTS ðñïáßñåóç ìÝóá óôï óôáãüíá ôñáðÝæé äÞëùóç. ãéá ðáñÜäåéãìá:
óôáãüíá ôñáðÝæétable_name CASCADE CONSTRAINTS;
The CASCADE CONSTRAINTS ðñïáßñåóç ìÝóá óôï óôáãüíá ôñáðÝæé SQL äÞëùóç èá ðåôá÷ôþ the áëëïäáðüò êëåéäß constraints ôïõ ðáéäß ôñáðÝæé ðáñáðïìðÞ.
åíáëëáêôéêÜ, åóý ìðïñåßs ÷åéñïðïßçôïs óôáãüíá êáé áðïìáêñýíù the áëëïäáðüò êëåéäß êëåéäß constraints ìÝóá Üëëïò ôñáðÝæé ðñéí performing the óôáãüíá ôñáðÝæé åã÷åßñçóç åðÜíù óå ãïíéüs ôñáðÝæé, óôáãüíá the áëëïäáðüò êëåéäß constraints ìÝóá Üëëïò ôñáðÝæé. óå åëÝã÷ù what constraints åßíáé ðáñáðïìðÞ Ýíás ôñáðÝæé ìÝóá Oracle, ÷ñÞóç the åðüìåíïò êüììá:
äéáëÝãù * áðü USER_CONSTRAINTS ðïý TABLE_NAME = “table_name“;
óå óôáãüíá êáé óâýíù the user constraints ìÝóá Oracle ÷ñÞóç the åðüìåíïò êüììá ìÝóá SQLPlus*, Toad Þ Üëëïò SQL åñãáëåßá:
ìåôáâÜëëù ôñáðÝæétable_name óôáãüíá CONSTRAINT constraint_name;
óçìáíôéêüò: áõôü åßíáé Ýíá ðïëõâüëï ìåôÝöñáóá óåëßäá ï ïðïßïò is ðñïìÞèåõóá " üðùò is" ÷ùñßs åããýçóç. ðïëõâüëï ìåôÜöñáóç ìðïñþ íá åßìáé äýóêïëïò óå understand. ðáñáêáëþ áíáöÝñïìáéðñùôüôõðïò ¢ããëïò Üñèñï ïðïôåäÞðïôå åßíáé äõíáôüí.
ìïéñÜæïìáé êáé contribute Þ áðïêôþ ôå÷íéêüò õðïóôçñßæù êáé âïÞèåéá óåMy øçöéáêüs æùÞ öüñïõì.
Related Üñèñï
- ORA-00942 ôñáðÝæé Þ èÝá Does ü÷é õðÜñ÷ù Oracle Error
- äçìéïõñãþ, ðñïóèÝôù Þ äéáóðþ Oracle âÜóç äåäïìÝíùí Partition áðïôõã÷Üíù ìå ORA-14080 Error
- Oracle âÜóç äåäïìÝíùí åéóÜãù Error 3113/3114
- Oracle ORA-14074 äçìéïõñãþ Þ ðñïóèÝôù êáéíïýñãéïò Partition áðïôõã÷Üíù Error
- ORA-01502 Oracle Index ìÝóá Unusable êáôÜóôáóç
- Oracle PL/SQL ORA-00947 ü÷é áñêåôüò áîßá Error
- Oracle ORA-01658 áíßêáíïò óå äçìéïõñãþ áñ÷éêÜ åðÝêôáóç ãéá Segment ìÝóá Tablespace Error
- ORA-25153 ðñïóùñéíüò Tablespace is êåíüò Error ìÝóá Oracle
- ÷åéñïðïßçôïs êáé êáèáñüò Uninstall Oracle ãiá Windïws
- Oracle EXP-00091 Error ðüôå åîÜãù âÜóç äåäïìÝíùí
si vous voulez des code dinvitation...
åßóïäïs (RSS)
ÖåâñïõÜñéïs 8th, 2007 1851:
what åÜí ìåôÜ dropping the ôñáðÝæé ÷ñçóéìïðïéþíôás the åñþôçóç öõóþ you èÝëù ðÜëé üëïò åêåßíïé constraints.
óôáãüíá ôñáðÝæé table_name CASCADE CONSTRAINTS;
ðáñáêáëþ ëÝù the åñþôçóç åÜí u ãíùñßæù.
Éïýëéïs 3rd, 2008 0630:
Constrangimentos? Orra, meu êÜíù åðáíÜëçøç essa tradução aà e äïêéìÜæù antes de ôá÷õäñïìéêÜ ôÝëç!!! Se não seja Ýíôéìïò e õðïäåéêíýù o óýíäåóìïò de onde pegou!!!
Éïýëéïs 24th, 2008 1321:
óðïõäáßïò The ðëçñïöïñßá ðñïìÞèåõóá is ðïëý âïÞèåéá. ìïéÜæåé óå íá åßìáé áðëü ìá áëÞèåéá halps Ýíás lot. åõ÷áñéóôþ ðÜëé.