Re: ORA-02270 error during import
Probably some one has already replied to this , in case yes then .just ignore ... Well this kind of problem is quite common. This is because the export does the export in alphabetical order and so the import does the same. If you contraints are based on tables which come later in the alpha order you will hit this problem. The best solution in this case is to import either at table level ( you will need to make sure of all the related tables are in a sequence). The other way is to disable all foreign constraints and load and then enable them again. Regards Ravinder Easaw T Mathew To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]<[EMAIL PROTECTED]> m> cc: Sent by: Subject: ORA-02270 error during import root@fatcity. com 26-Jun-2001 08:20 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book hi Error during import: ORA-02270: no matching unique or primary key for this column-list i am in the process of migrating my oracle databases from dg/ux to solaris8 OS. at the same time, i am taking the opportunity to resize the tables, indexes to cater for growth in the near future. to do this, i hv created fresh the new database with improved settings (given the luxury of disk space we hv now), created the tables and indexes with new sizings, moved the export over to the new machine and reimported it. the export was a full export. on import, i get the above error which means that it cant create a foreign key constraint becos the primary key constraint for the table has not been created. this is the case for quite a few of the tables but most of the 400 or so tables were fine. why should this occur and under what circumstances wld this occur? and how do i fix this? almost all the documentation i hv checked including oracle web sites do not offer a solution and I am not sure the best way forward without a lot of workaround being done which may not be ideal. wld any Oracle gurus be kind enough offer any ideas or thoughts on this except that the export/import utility is probably buggy. many thanx Easaw T Mathew -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Easaw T Mathew INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services
Re: ORA-02270 error during import
Easaw, It appears that you are trying to import the child table before the parent table exists. I think the disabeling the constraint before you export should help. Or break the export into smaller parts and export the tables in different dmp files then import them in the proper order for the constraints to work. ROR mª¿ªm >>> [EMAIL PROTECTED] 06/26/01 08:20AM >>> hi Error during import: ORA-02270: no matching unique or primary key for this column-list i am in the process of migrating my oracle databases from dg/ux to solaris8 OS. at the same time, i am taking the opportunity to resize the tables, indexes to cater for growth in the near future. to do this, i hv created fresh the new database with improved settings (given the luxury of disk space we hv now), created the tables and indexes with new sizings, moved the export over to the new machine and reimported it. the export was a full export. on import, i get the above error which means that it cant create a foreign key constraint becos the primary key constraint for the table has not been created. this is the case for quite a few of the tables but most of the 400 or so tables were fine. why should this occur and under what circumstances wld this occur? and how do i fix this? almost all the documentation i hv checked including oracle web sites do not offer a solution and I am not sure the best way forward without a lot of workaround being done which may not be ideal. wld any Oracle gurus be kind enough offer any ideas or thoughts on this except that the export/import utility is probably buggy. many thanx Easaw T Mathew -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Easaw T Mathew INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-02270 error during import
hi Error during import: ORA-02270: no matching unique or primary key for this column-list i am in the process of migrating my oracle databases from dg/ux to solaris8 OS. at the same time, i am taking the opportunity to resize the tables, indexes to cater for growth in the near future. to do this, i hv created fresh the new database with improved settings (given the luxury of disk space we hv now), created the tables and indexes with new sizings, moved the export over to the new machine and reimported it. the export was a full export. on import, i get the above error which means that it cant create a foreign key constraint becos the primary key constraint for the table has not been created. this is the case for quite a few of the tables but most of the 400 or so tables were fine. why should this occur and under what circumstances wld this occur? and how do i fix this? almost all the documentation i hv checked including oracle web sites do not offer a solution and I am not sure the best way forward without a lot of workaround being done which may not be ideal. wld any Oracle gurus be kind enough offer any ideas or thoughts on this except that the export/import utility is probably buggy. many thanx Easaw T Mathew -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Easaw T Mathew INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).