oracle数据库导入导出有问题,
来源:百度知道 编辑:UC知道 时间:2024/05/06 11:13:33
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>exp
Export: Release 9.2.0.6.0 - Production on 星期日 12月 17 08:35:43 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
用户名: ncgj
口令:
连接到: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
输入数组提取缓冲区大小: 4096 > d:\fdf.dmp
输入数组提取缓冲区大小: 4096 >
导出文件: EXPDAT.DMP>
(1)E(完整的数据库),(2)U(用户) 或 (3)T(表): (2)U > a
EXP-00030: 读取输入值时出现意外的 EOF^C
C:\Documents and Settings\Administrator>exp
Export: Release 9.2.0.6.0 - Production on 星期日 12月 17 08:36:07 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
用户名: ncgj
口令:
连接到: Oracle9i Enterprise Edition
这个原因........看起来应该是没有执行一个脚本
Rerun the ORACLE_HOME/rdbms/admin/catexp.sql script.这个东西,你看一下。
Metalink Doc-IDs:
143762.995
296371.999
这个是metalink对这个错误的解释。
Subject: EXPORT ERROR AFTER PUT PATCHSET 8.1.7.2.1
RDBMS Version: 8.1.7.0.0
Operating System and Version: NT 4.0
Error Number (if applicable): EXP-00008; ORA-00904
Product (i.e. SQL*Loader, Import, etc.): EXPORT
Product Version: 8.1.7.2.1
EXPORT ERROR AFTER PUT PATCHSET 8.1.7.2.1
After apply patchset 8.1.7.2.1 on 8.1.7.0.0 hosted NT 4.0, the EXP show error message when exporting
user from database 8.1.7.0.0 located on HP-UX 11.0.
Error as follow:
D:\jason\exp>exp system@prd1
Export: Release 8.1.7.2.1 - Production on Fri Oct 5 11:29:51 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Password:*****
Connected to: Oracle8i Enterprise