imp 导入 oracle 问题
导出、导入都是 oracle 10g 。
在导入过程中出现如下情况:
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50658C'; SREC"
".MAXVAL := '9F9996E8798F'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARAR"
"RAY('NNPe','N ?Q穅揚 <s韀','N ?冘^','NT^\','N巐8fz','N巐齟','N巑裧p',
'N帟"
............................
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: line 1, column 1350:
PLS-00103: Encountered the symbol "," when expecting one of the following:
. ( * % & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
ORA-06550: line 1, column 1450:
PLS-00103: Encountered the symbol "." when expecting one of the following:
) , =>
. . 正在导入表 "SF_DEPT_MAIN"导入了 36 行
最后数据库导入成功
请教一下这到底是什么问题,我在网上查了很久
相关问答:
delphi 怎么将oracle的long raw 字段值 导入blob字段
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
看看这个
引用
vStream := TMemorySt ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
我写的一个Job
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
大家好,在开发的时候,遇到这样的问题:
未能加载文件或程序集“Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342”或它的某一个依赖项。系统找不到指定的文件。 ......
数据泵导入报如下错误ORA-39016 不知道是什么原因,请指教.... 谢谢'
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39016: Operation not supported when job is in EXECUTING ......