当前位置: 代码迷 >> Oracle管理 >> IMP-00032: SQL 话语超过缓冲区长度IMP-00008: 导出文件中出现无法识别的语句
  详细解决方案

IMP-00032: SQL 话语超过缓冲区长度IMP-00008: 导出文件中出现无法识别的语句

热度:22   发布时间:2016-04-24 05:15:39.0
IMP-00032: SQL 语句超过缓冲区长度IMP-00008: 导出文件中出现无法识别的语句:
现在数据库中的用户经常会被lock掉
unlock后过会还会lock掉
然后我把导出的数据进行导入会出现下面的错误,请问要怎么解决谢谢
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'Oracle_Database returns one entry for each database that is managed by Oracle
Enterprise Manager. View entries are created using the databases that are known
to the Enterprise Manager Management Repository. Note: A Real Application
Cluster is presented...
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'Oracle_DatabaseInstance contains one entry for each Oracle Instance that is
centrally managed. A Real Application Cluster has one entry for each of the
instances that manipulate it. Instances of Oracle_DatabaseInstance are created
using the database ...
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'An Oracle_DatabaseSystem represents the existence of an Oracle database
environment as a manageable entity. Instances of Oracle_DatabaseSystem are
used to navigate to the software characteristics of the database environment
that are modeled within the...
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'The AssociatedDBSystem association identifies the database system that was used
to create the database.This association links an Oracle Database with
thedatabase system elements that are related.'
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'The InstanceAvailableToDB association relates an Oracle database and its
instances.'
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'Oracle_DBInstanceStatistics contains statistics for a database instance. These
are retrieved from the Oracle Managment Repository that is managing the
database upon request from a managment client.'
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'Oracle_DatabaseStatistics provides current information about the statistics for
a database. Database statistics pertain to the database and have the same
value regardless of the database instance that is used.'
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'Oracle_CurrentDBInstanceStats is an association that relates a Oracle database
instance to its current statistical information.'
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句:  
'Oracle_CurrentDBStatistics is an association that relates a Oracle database to
its current statistical information.'
即将启用约束条件...
成功终止导入, 但出现警告。


------解决方案--------------------
引用楼主 mailguoyy 的帖子:
现在数据库中的用户经常会被lock掉
unlock后过会还会lock掉
然后我把导出的数据进行导入会出现下面的错误,请问要怎么解决谢谢
IMP-00032: SQL 语句超过缓冲区长度
IMP-00008: 导出文件中出现无法识别的语句: 
'Oracle_Database returns one entry for each database that is managed by Oracle
Enterprise Manager. View entries are created using the databases that are known
to the Enterprise Manager Management …

------解决方案--------------------
imp再加个buffer=10000000

还不行的话,你把exp和imp的详细语句贴出来。以及exp和imp的版本号。


------解决方案--------------------
帮顶
------解决方案--------------------
探讨
这个可能是该用户属性文件的设置问题。看看该user的属性文件中的设置。
还有每次被锁前有什么特定操作吗?比如密码连续输错。