During Import Err [message #278896] |
Tue, 06 November 2007 03:44 |
babuknb
Messages: 1736 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
|
|
|