Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

why only a DBA can Import?

The_RockMar 10 2010 — edited Mar 10 2010
I am exporting with normal user RAKESH, and when I do Import with RAKESH user I get *"only a DBA can import a file exported by another DBA"*

H:\>exp rakesh/rakesh@testapp file=d:\rakesh.dmp log=D:\rakesh.log

Export: Release 10.2.0.1.0 - Production on Wed Mar 10 12:50:57 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2700
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting foreign function library names for user RAKESH
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user RAKESH
About to export RAKESH's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export RAKESH's tables via Conventional Path ...
. . exporting table A 4 rows exported
. . exporting table TSTLOCK 5 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_EXP", line 2700
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.

H:\>

H:\>imp rakesh/rakesh@testapp file=d:\rakesh.dmp log=D:\rakesh_imp.log

Import: Release 10.2.0.1.0 - Production on Wed Mar 10 12:51:32 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

H:\>
Why a ONLY A DBA can Import?
This post has been answered by asifkabirdba on Mar 10 2010
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 7 2010
Added on Mar 10 2010
#database-key-features, #export-import-sql-loader-external-tables
2 comments
2,616 views