欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

EXP-00032: Non-DBAs may not export other users

程序员文章站 2022-07-02 17:12:23
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Applicatio ......

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
EXP-00032: Non-DBAs may not export other users
EXP-00000: Export terminated unsuccessfully

 

提示需要dba权限,加个exp_full_database权限即可

grant exp_full_database to user1

同理:

IMP-00013: only a DBA can import a file exported by another DBA

提示需要dba权限,加个imp_full_database权限即可

grant imp_full_database to user1