Home » RDBMS Server » Server Utilities » During Import Err (Oracle 9i, R2 + Windows 2000)
During Import Err [message #278896] Tue, 06 November 2007 03:44
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hi,

In oracle 9i R2, I'm exported particulare user and imported another user in same database.

But i'm facing some error. May i know reason for this error

 Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by TRADINGJAP, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing TRADINGJAP's objects into TRADINGJAPOLD
. . importing table              "DM_PRODUCTSTOCK"         97 rows imported
. . importing table          "DM_PRODUCTSTOCKFULL"         97 rows imported
. . importing table   "TEMP_DM_PRODUCTSTOCK240307"         97 rows imported
. . importing table "TEMP_DM_PRODUCTSTOCKFULL240307"         97 rows imported
. . importing table     "TSADJUSTMENTREASONMASTER"          0 rows imported
. . importing table      "TSAPPLICATIONAREAMASTER"          0 rows imported
. . importing table               "TSARNOREGISTER"         97 rows imported
. . importing table                 "TSBANKMASTER"          0 rows imported
. . importing table          "TSBINLOCATIONMASTER"          3 rows imported
. . importing table               "TSBRANCHMASTER"          1 rows imported
. . importing table           "TSBRANCHTYPEMASTER"          0 rows imported
. . importing table        "TSCLINICALSTUDYMASTER"          0 rows imported
. . importing table                     "TSCOADTL"          0 rows imported
. . importing table                "TSCOADTLMICRO"          0 rows imported
. . importing table                     "TSCOAMST"          0 rows imported
. . importing table                      "TSCODTL"          0 rows imported
. . importing table              "TSCOMPANYMASTER"          1 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '5453303730303030303"
 "1'; SREC.MAXVAL := '54533037303030303032'; SREC.EAVS := 4; SREC.CHVALS := D"
 "BMS_STATS.CHARARRAY(DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := "
 "'54533037303030303031'; SREC.MAXVAL := '54533037303030303032'; SREC.EAVS :="
 " 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(,0000000000000); SREC.NOVALS := DBM"
 "S_STATS.NUMARRAY(437840196145761000000000000000000000,437840196145761000000"
 "000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; D"
 "BMS_STATS.SET_COLUMN_STATS(NULL,'"TSCOMPANYMASTER"','"LANGUAGE_CODE"', NULL"
 " ,NULL,NULL,2,.0833333333333333,0,srec,11,2); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 171:
PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following:

   ( ) - + case mod new not null others <an identifier>
   <a double-quoted delimited-identifier> <a bind variable>
   table avg count current exists max min prior sql stddev sum
   variance execute multiset the both leading trailing forall
   merge year month DAY_ hour minute second timezone_hour
   timezone_minute timezone_region timezone_abbr time timestamp
   interval date
   <a string liter
. . importing table                      "TSCOMST"          0 rows imported
. . importing table              "TSCOUNTRYMASTER"         84 rows imported
. . importing table         "TSCREDITPERIODMASTER"          0 rows imported
. . importing table                  "TSCRMMASTER"          0 rows imported 


Babu B
Previous Topic: expdp error
Next Topic: Purge Recyclebin
Goto Forum:
  


Current Time: Mon Dec 05 12:39:25 CST 2016

Total time taken to generate the page: 0.07383 seconds