Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Weid exp/imp problem

RE: Weid exp/imp problem

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Wed, 19 Dec 2001 06:38:21 -0800
Message-ID: <F001.003DFF1B.20011219054021@fatcity.com> 













<font size=2 color=navy



face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'>Helmut:



<font size=2 color=navy



face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'> 



<font size=2 color=navy



face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'>  This


could be due to the fact that constraints on those tables have not been defined
yet.  Since tables are imported in


Alpha order, I would suggest performing a no-data import after this one is
complete.



<font size=2 color=navy



face="Comic Sans MS"><span style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
font-family:"Comic Sans MS"'> 



<!---size:11.0pt;



mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'><span style='mso-element:
field-begin'> AUTOTEXTLIST 


\s "E-mail Signature" <span


class=EmailStyle18><i style='mso-bidi-font-style:
normal'><span


style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:"Monotype Corsiva";
color:#3366FF;font-weight:bold;font-style:italic'>Thank You



<font size=2 color=black



face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'> 



<b style='mso-bidi-font-weight:



normal'><span style='font-size:11.0pt;


mso-bidi-font-size:12.0pt;font-family:Tahoma;mso-bidi-font-family:Arial;
color:blue;font-weight:bold'>Stephen P. Karniotis



<font size=2 color=red



face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Technical
Alliance Manager



<font size=2 color=red



face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Compuware
Corporation



<font size=2 color=red



face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Direct:<span
style='mso-tab-count:1'>          (248)


865-4350



<font size=2 color=red



face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Mobile:<span
style='mso-tab-count:1'>          (248)


408-2918



<font size=2 color=red



face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Email:<span
style='mso-tab-count:1'>             <a


href="mailto:Stephen.Karniotis_at_Compuware.com"><span
style='font-size:12.0pt;color:red'>Stephen.Karniotis_at_Compuware.com



<font size=2 color=red



face=Haettenschweiler><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Haettenschweiler;color:red;mso-bidi-font-weight:bold'>Web:<span
style='mso-tab-count:1'>              <a
href="http://www.compuware.com/"><span style='font-size:
12.0pt;color:red'>www.compuware.com



<font size=2 color=black



face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial;mso-bidi-font-weight:bold'> 



<!---size:11.0pt;



mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'><span style='mso-element:
field-end'><font


size=2 color=navy face="Comic Sans MS"><span style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Comic Sans MS"'> 



<font size=2 color=black



face=Tahoma>-----Original


Message-----


From: Daiminger, Helmut


[mailto:Helmut.Daiminger_at_KirchGruppe.de]
Sent: Wednesday, December 19, 2001


3:25 AM


To: Multiple recipients of list


ORACLE-L



Subject: Weid exp/imp problem



<span



style='font-size:12.0pt'> 



<span



style='font-size:10.0pt;color:black'>Hi!<span
style='color:black'> <span style='color:black;
mso-color-alt:windowtext'>



<span



style='font-size:10.0pt;color:black'>I'm experiencing a weird problem here...
I'm about to move one user's object from the development box to a test box. The
user's rights on both boxes are identical.<span
style='color:black;mso-color-alt:windowtext'>



<span



style='font-size:10.0pt;color:black'>What I do is  this: <font
color=black>


<span style='font-size:10.0pt;



color:black'>- export user (using exp) from development. Works flawlessly.<font
color=black> 


<span style='font-size:10.0pt;



color:black'>- import user into the other box (user setup and tablespaces are
identical) <font


color=black>



<span



style='font-size:10.0pt;color:black'>An I get the following errors which
doesn't make a lot of sense to me...<span
style='color:black'> 


<span style='font-size:10.0pt;



color:black'>... 


<span style='font-size:10.0pt;



color:black'>. . importing

table                    




"TABELLEN"         37 rows


imported 


<span style='font-size:10.0pt;



color:black'>. . importing table        
"TABELLEN_ZUORDNUNGEN"        



28 rows imported 


<span style='font-size:10.0pt;



color:black'>. . importing

table                    




"TMP$TEST"          1



rows imported 


<span style='font-size:10.0pt;



color:black'>. . importing table     


"TMP_FUNKTIONS_PARAMETER"         



0 rows imported 


<span style='font-size:10.0pt;



color:black'>. . importing table       


"TMP_FUNKTIONS_SPALTEN"         



0 rows imported 


<span style='font-size:10.0pt;



color:black'>. . importing

table                    




"USEREXIT"          5



rows imported 


<span style='font-size:10.0pt;



color:black'>. . importing


table               


"USEREXIT_TYPE"         



3 rows imported 


<span style='font-size:10.0pt;



color:black'>. . importing

table                      




"ZYKLUS"          7 rows


imported 


<span style='font-size:10.0pt;



color:black'>IMP-00017: following statement failed with ORACLE error 2270:<font
color=black> 


<span style='font-size:10.0pt;



color:black'> "ALTER TABLE "BENUTZER_GRUPPEN_ZUORD" ADD
CONSTRAINT "BNGRZ_BNGR_FK" FOREIGN"<font
color=black> 


<span style='font-size:10.0pt;



color:black'> " KEY ("BNGR_ID") REFERENCES
"BENUTZER_GRUPPEN" ("ID") ENABLE NOVALIDATE"<font
color=black> 


<span style='font-size:10.0pt;



color:black'>IMP-00003: ORACLE error 2270 encountered<font
color=black> 


<span style='font-size:10.0pt;



color:black'>ORA-02270: no matching unique or primary key for this column-list<font
color=black> 


<span style='font-size:10.0pt;



color:black'>IMP-00017: following statement failed with ORACLE error 2270:<font
color=black> 


<span style='font-size:10.0pt;



color:black'> "ALTER TABLE "BENUTZER_GRUPPEN_ZUORD" ADD
CONSTRAINT "BNGRZ_OW_FK" FOREIGN K"<font
color=black> 


<span style='font-size:10.0pt;



color:black'> "EY ("OW_ID") REFERENCES "OWNER"
("ID") ENABLE NOVALIDATE"<span


style='color:black'> 


<span style='font-size:10.0pt;



color:black'>IMP-00003: ORACLE error 2270 encountered<font
color=black> 


<span style='font-size:10.0pt;



color:black'>ORA-02270: no matching unique or primary key for this column-list<font
color=black> 


<span style='font-size:10.0pt;



color:black'>... <font


color=black>



<span


style='font-size:10.0pt;color:black'>Any ideas why this is happening?<font
color=black> <span
style='color:black;mso-color-alt:windowtext'>





<span


style='font-size:10.0pt;color:black'>This is 8.1.7 on Sun Solaris.<font
color=black> <span
style='color:black;mso-color-alt:windowtext'>





<span



style='font-size:10.0pt;color:black'>Thanks,<span
style='color:black'> 


<span style='font-size:10.0pt;



color:black'>Helmut <font


color=black>
Received on Wed Dec 19 2001 - 08:38:21 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US