Strange things about import

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Wed, 13 Sep 2000 17:16:28 -0400
Message-Id: <10618.116903@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C01DC7.E1F49530
Content-Type: text/plain;

charset="iso-8859-1"

I made a full export - finished without wornings and then made fromuser touser import into empty user. It gave me stranfe errror. 8.1.6.2 on Solaris.

Do not have support yet. Any ideas?

Alex Hillman

Import: Release 8.1.6.2.0 - Production on Wed Sep 13 17:02:38 2000

Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option
JServer Release 8.1.6.2.0 - Production

Export file created by EXPORT:V08.01.06 via conventional path import done in US7ASCII character set and US7ASCII NCHAR character set . importing XXXXXXX's objects into YYYY

. . importing table                "ADJUST_METHOD"          4 rows imported

.....

. . importing table           "PERMIT_MEMBER_TYPE"          3 rows imported
. . importing table             "PERSESS_ACTIVITY"      12572 rows imported

IMP-00017: following statement failed with ORACLE error 6550: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4141525020434F4D4D2"
"0496E737572616E636520636F76657261676520616464'; SREC.MAXVAL := '706F7374726"
"566756E6420272720636C61696D203C6120687265663D272F696E'; SREC.EAVS := 4; SRE"

 "C.CHVALS := DBMS_STATS.CHARARRAY('AARP COMM Insurance coverage add','BCBS
P"
 "PO Insurance coverage adde','Checkin <a href='/person/DASCABO','Checkin <a

"

"href='/person/RTSMITH','Fee Schedule Entry ' ' <a href='','Fee Schedule Ent"
"ry '1224 ' <a hr','Fee Schedule Entry '197 ' <a hre','Fee Schedule Entry '3"
"42 ' <a hre','Fee Schedule Entry '712 ' <a hre','FeeSchedule 'FFS STANDARD
"

"FEES' ','Insurance 'AETNA DE 7012' in <a ','Insurance 'ALLMERICA' in <a hre"
"f','Insurance 'BCBS COMM' in <a href','Insurance 'EMPLOYER PLAN PPO' in','I"
"nsurance 'HAS PPO' in <a href='','Insurance 'IEC BENEFIT PPO' in <','Insura"

 "nce 'NEW ENGLAND EMPLOYEE ','Insurance 'PHEONIX PPO' in <a hr','Insurance
'"
 "THE TPA' in <a href='','Insurance 'UNITED169075' in <a h','Medicaid

Insuran"
"ce coverage adde','Organization 'ABBLUMMUS' <a href','Organization 'CNA' <a"
" href='/org','Organization 'HCPROFESSION' <a h','Organization 'NALCOCHEMCO'"
" <a hr','Organization 'TEXASAM' <a href='','Person '020693' <a

href='/perso"
 "n','Person '024590' <a href='/person','Person '028050' <a
href='/person','P"

"erson '028330' <a href='/person','Person '080319' <a href='/person','Person"
" 'BDAMBACH-MOLINA' <a href','Person 'JBROUSSARD' <a href='/pe','Person 'MLO"
"RTIZ' <a href='/perso','Person 'SROBERTS' <a href='/pers','Procedure to cl"
"aim <a href='/in','Procedure 2011 to claim <a href=','Procedure 3512 to cla"
"im <a href=','appointment 'AGCRUZ' <a href='/p','appointment 'Event ' <a hr"

 "ef='/p','appointment 'Event 91' <a href='','claim '1071' to <a
href='/perso"
 "n','claim '1245' to <a href='/person','claim '1456' to <a
href='/person','c"

"laim '222' to <a href='/person/','claim '363' to <a href='/person/','claim
"

"'506' to <a href='/person/','claim '666' to <a href='/person/','claim '807'"
" to <a href='/person/','claim '97' to <a href='/person/T','postrefund '' cl"
"aim <a href='/in'); SREC.NOVALS :=
DBMS_STATS.NUMARRAY(33882417393613200000"
"0000000000000000,344055768891790000000000000000000000,350001292933896000000
"

"000000000000000,350001292933896000000000000000000000,3655173155161510000000
"

"00000000000000,365517315516151000000000000000000000,36551731551615100000000
"

"0000000000000,365517315516151000000000000000000000,365517315516151000000000
"

"000000000000,365517331319253000000000000000000000,3812778833161570000000000
"

"00000000000,381277883316157000000000000000000000,38127788331615700000000000
"

"0000000000,381277883316157000000000000000000000,381277883316157000000000000
"

"000000000,381277883316157000000000000000000000,3812778833161570000000000000
"

"00000000,381277883316157000000000000000000000,38127788331615700000000000000
"

"0000000,381277883316157000000000000000000000,401863336909472000000000000000
"

"000000,412511837173333000000000000000000000,4125118371733330000000000000000
"

"00000,412511837173333000000000000000000000,41251183717333300000000000000000
"

"0000,412511837173333000000000000000000000,417441339788769000000000000000000
"

"000,417441339788769000000000000000000000,4174413397887690000000000000000000
"

"00,417441339788769000000000000000000000,41744133978876900000000000000000000
"

"0,417441339788769000000000000000000000,417441339788769000000000000000000000
"

",417441339788769000000000000000000000,417441339788769000000000000000000000,
"

"417704768465233000000000000000000000,417704768465233000000000000000000000,4
"

"17704768465233000000000000000000000,505933333187984000000000000000000000,50
"

"5933333187984000000000000000000000,505933333187984000000000000000000000,516
"

"235606991757000000000000000000000,516235606991757000000000000000000000,5162
"

"35606991757000000000000000000000,516235606991757000000000000000000000,51623
"

"5606991757000000000000000000000,516235606991757000000000000000000000,516235
"

"606991757000000000000000000000,516235606991757000000000000000000000,5162356
"

 "06991757000000000000000000000,583797742899153000000000000000000000);

SREC.B"
"KVALS :=
DBMS_STATS.NUMARRAY(0,1,2,3,29,30,31,32,33,34,35,36,37,38,39,40,41"
",42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66
"

",67,68,69,70,71,72,73,74,75); SREC.EPC := 51; DBMS_STATS.SET_COLUMN_STATS(N"
"ULL,'PERSESS_ACTIVITY','ACTIVITY_DATA',NULL,NULL,NULL,5163,.001558133708103
"

"46,10,srec,69,0); END;"

IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 362:
PLS-00103: Encountered the symbol "," when expecting one of the following:

. ( ) , * @ % & | = - + < / > at in mod not rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like between is null is not || is dangling

. . importing table           "PERSESS_VIEW_COUNT"       2922 rows imported
. . importing table                       "PERSON"       2096 rows imported

........
. . importing table                "WRITEOFF_TYPE"         11 rows imported

About to enable constraints...
Import terminated successfully with warnings.

------_=_NextPart_001_01C01DC7.E1F49530
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0">

<TITLE>Strange things about import</TITLE>
</HEAD>
<BODY>

I made a full export - finished = without wornings and then made fromuser touser import into empty user. = It gave me stranfe errror.

8.1.6.2 on Solaris.

Do not have support yet. Any = ideas?

Alex Hillman

Import: Release 8.1.6.2.0 - Production = on Wed Sep 13 17:02:38 2000

(c) Copyright 1999 Oracle = Corporation.  All rights reserved.

Connected to: Oracle8i Enterprise = Edition Release 8.1.6.2.0 - Production With the Partitioning option JServer Release 8.1.6.2.0 - = Production

Export file created by = EXPORT:V08.01.06 via conventional path import done in US7ASCII character set = and US7ASCII NCHAR character set

<BR><FONT SIZE=3D2 FACE=3D"Arial">. importing XXXXXXX's objects into =
YYYY</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">. . importing =

table           &= nbsp;    =
"ADJUST_METHOD"       &nbsp= ;  4 rows imported

.....

. . importing = table           = "PERMIT_MEMBER_TYPE"       =    3 rows imported
 . . importing = table           &= nbsp; "PERSESS_ACTIVITY"      12572 = rows imported
 IMP-00017: following statement failed = with ORACLE error 6550:
  "DECLARE  SREC = DBMS_STATS.STATREC; BEGIN SREC.MINVAL :=3D = '4141525020434F4D4D2"
  "0496E737572616E636520636F76657261676520616464= '; SREC.MAXVAL :=3D '706F7374726"  "566756E6420272720636C61696D203C6120687265663D= 272F696E'; SREC.EAVS :=3D 4; SRE"  "C.CHVALS :=3D = DBMS_STATS.CHARARRAY('AARP COMM Insurance coverage add','BCBS = P"
  "PO Insurance coverage = adde','Checkin <a href=3D'/person/DASCABO','Checkin <a = "
  "href=3D'/person/RTSMITH','Fee Schedule Entry = ' ' <a href=3D'','Fee Schedule Ent"  "ry '1224 ' <a hr','Fee = Schedule Entry '197 ' <a hre','Fee Schedule Entry '3"  "42 ' <a hre','Fee = Schedule Entry '712 ' <a hre','FeeSchedule 'FFS STANDARD = "
  "FEES' ','Insurance 'AETNA = DE 7012' in <a ','Insurance 'ALLMERICA' in <a hre"  "f','Insurance 'BCBS COMM' = in <a href','Insurance 'EMPLOYER PLAN PPO' in','I"  "nsurance 'HAS PPO' in = <a href=3D'','Insurance 'IEC BENEFIT PPO' in = <','Insura"
  "nce 'NEW ENGLAND EMPLOYEE = ','Insurance 'PHEONIX PPO' in <a hr','Insurance '"  "THE TPA' in <a = href=3D'','Insurance 'UNITED169075' in <a h','Medicaid = Insuran"
  "ce coverage = adde','Organization 'ABBLUMMUS' <a href','Organization 'CNA' = <a"
  " = href=3D'/org','Organization 'HCPROFESSION' <a h','Organization = 'NALCOCHEMCO'"
  " <a hr','Organization = 'TEXASAM' <a href=3D'','Person '020693' <a = href=3D'/perso"
  "n','Person '024590' <a = href=3D'/person','Person '028050' <a = href=3D'/person','P"
  "erson '028330' <a = href=3D'/person','Person '080319' <a = href=3D'/person','Person"
  " 'BDAMBACH-MOLINA' <a = href','Person 'JBROUSSARD' <a href=3D'/pe','Person 'MLO"  "RTIZ' <a = href=3D'/perso','Person 'SROBERTS' <a = href=3D'/pers','Procedure  to cl"  "aim <a = href=3D'/in','Procedure 2011 to claim <a href=3D','Procedure 3512 to = cla"
  "im <a = href=3D','appointment 'AGCRUZ' <a href=3D'/p','appointment 'Event ' = <a hr"
  "ef=3D'/p','appointment = 'Event 91' <a href=3D'','claim '1071' to <a = href=3D'/perso"
  "n','claim '1245' to <a = href=3D'/person','claim '1456' to <a = href=3D'/person','c"
  "laim '222' to <a = href=3D'/person/','claim '363' to <a href=3D'/person/','claim = "
  "'506' to <a = href=3D'/person/','claim '666' to <a href=3D'/person/','claim = '807'"
  " to <a = href=3D'/person/','claim '97' to <a href=3D'/person/T','postrefund = '' cl"
  "aim <a href=3D'/in'); = SREC.NOVALS :=3D DBMS_STATS.NUMARRAY(33882417393613200000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;0000000000000000,3440557688917900000000000000=

00000000,350001292933896000000"  "000000000000000,35000129293389600000000000000= 0000000,3655173155161510000000"  "00000000000000,365517315516151000000000000000= 000000,36551731551615100000000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;0000000000000,3655173155161510000000000000000=

00000,365517315516151000000000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;000000000000,36551733131925300000000000000000=

0000,3812778833161570000000000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;00000000000,381277883316157000000000000000000=

000,38127788331615700000000000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;0000000000,3812778833161570000000000000000000=

00,381277883316157000000000000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;000000000,38127788331615700000000000000000000=

0,3812778833161570000000000000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;00000000,381277883316157000000000000000000000=

,38127788331615700000000000000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;0000000,381277883316157000000000000000000000,=

401863336909472000000000000000" <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;000000,412511837173333000000000000000000000,4=
125118371733330000000000000000&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;00000,412511837173333000000000000000000000,41=
251183717333300000000000000000&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;0000,412511837173333000000000000000000000,417=
441339788769000000000000000000&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;000,417441339788769000000000000000000000,4174=
413397887690000000000000000000&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;00,417441339788769000000000000000000000,41744=
133978876900000000000000000000&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;0,417441339788769000000000000000000000,417441=
339788769000000000000000000000&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;,417441339788769000000000000000000000,4174413=
39788769000000000000000000000,&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;417704768465233000000000000000000000,41770476=
8465233000000000000000000000,4&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;17704768465233000000000000000000000,505933333=
187984000000000000000000000,50&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;5933333187984000000000000000000000,5059333331=
87984000000000000000000000,516&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;235606991757000000000000000000000,51623560699=
1757000000000000000000000,5162&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;35606991757000000000000000000000,516235606991=
757000000000000000000000,51623&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;5606991757000000000000000000000,5162356069917=
57000000000000000000000,516235&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;606991757000000000000000000000,51623560699175=
7000000000000000000000,5162356&quot;</FONT>

<FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&quot;06991757000000000000000000000,583797742899153=
000000000000000000000); SREC.B&quot;</FONT>

"KVALS :=3D = DBMS_STATS.NUMARRAY(0,1,2,3,29,30,31,32,33,34,35,36,37,38,39,40,41"= 
  ",42,43,44,45,46,47,48,49,50,51,52,53,54,55,56= ,57,58,59,60,61,62,63,64,65,66"  ",67,68,69,70,71,72,73,74,75); SREC.EPC :=3D = 51; DBMS_STATS.SET_COLUMN_STATS(N"  "ULL,'PERSESS_ACTIVITY','ACTIVITY_DATA',NULL,N= ULL,NULL,5163,.001558133708103"  "46,10,srec,69,0); = END;"
 IMP-00003: ORACLE error 6550 = encountered
 ORA-06550: line 1, column 362: PLS-00103: Encountered the symbol = "," when expecting one of the following:

. ( ) , * @ % & | =3D = - + < / > at in mod not rem =3D> ..    <an exponent (**)> = <> or !=3D or ~=3D >=3D <=3D <> and or like    between is null is not = || is dangling
 . . importing = table           = "PERSESS_VIEW_COUNT"       2922 = rows imported
 . . importing = table           &= nbsp;           = "PERSON"       2096 rows = imported

........ . . importing = Received on Wed Sep 13 2000 - 16:16:28 CDT