IMP - 00003: ORACLE error 20000
ORA - 20000: the TABLE "HXDB". "HNU_DEVICE_STATE" does not exist or insufficient privileges
ORA - 06512: in the "SYS. DBMS_STATS", line 3007
ORA - 06512: in the "SYS. DBMS_STATS", line 7303
ORA - 06512: in the line 1
IMP - 00017:20000 due to ORACLE error, the following statement failure:
"DECLARE SREC DBMS_STATS. STATREC; The BEGIN SREC. MINVAL:='80'; SREC. Very:="
"' C10A '; SREC. EAVS:=0; SREC. CHVALS:=NULL; SREC. NOVALS:=DBMS_STATS. NUM "
"ARRAY (0, 9); SREC. BKVALS:=DBMS_STATS. NUMARRAY (0, 1); SREC. EPC:=2; DBMS_ST
""ATS. SET_COLUMN_STATS (NULL, '" HNU_DEVICE_STATE"', '" VAL0350 ", NULL, NULL, NULL
"", 8, 125 ploidy, srec, 3, 6); END."
IMP - 00003: ORACLE error 20000
ORA - 20000: the TABLE "HXDB". "HNU_DEVICE_STATE" does not exist or insufficient privileges
ORA - 06512: in the "SYS. DBMS_STATS", line 3007
ORA - 06512: in the "SYS. DBMS_STATS", line 7303
ORA - 06512: in the line 1
IMP - 00017:20000 due to ORACLE error, the following statement failure:
"DECLARE SREC DBMS_STATS. STATREC; The BEGIN SREC. MINVAL:='80'; SREC. Very:="
"' C10A '; SREC. EAVS:=0; SREC. CHVALS:=NULL; SREC. NOVALS:=DBMS_STATS. NUM "
"ARRAY (0, 9); SREC. BKVALS:=DBMS_STATS. NUMARRAY (0, 1); SREC. EPC:=2; DBMS_ST
""ATS. SET_COLUMN_STATS (NULL, '" HNU_DEVICE_STATE"', '" VAL0355 ", NULL, NULL, NULL
"", 8, 125 does, srec, 3, 6); END."
Seek help from a great god,
Versions of the oracle server is 12 g, I put the database export into format of DMP, and then into 11 g imported into the local database oracle 11 g, now is some tables come in, some tables of don't come in,
CodePudding user response:
Export and import statements?CodePudding user response:
In addition, if the version from high to low version migration data, it is best to low version of the client export and import, this is a general rule, but cannot guarantee that there is no problem,In addition, your problem now may have nothing to do with this rule
CodePudding user response:
Oracle is backwards compatible,Does not support high version export, import low version,
Only support low version of export, import high version,
Of course, the same version of import and export is also no problem,
CodePudding user response:
I when the database import operation, with the imp import data, the result error