From Stephen_Karniotis@compuware.com Wed, 19 Dec 2001 06:38:21 -0800
From: "Karniotis, Stephen" <Stephen_Karniotis@compuware.com>
Date: Wed, 19 Dec 2001 06:38:21 -0800
Subject: RE: Weid exp/imp problem
Message-ID: <F001.003DFF1B.20011219054021@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: Weid exp/imp problem









<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@Compuware.com"><span
style='font-size:12.0pt;color:red'>Stephen.Karniotis@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@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>