469,358 Members | 1,659 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,358 developers. It's quick & easy.

problem in importing a .dmp file

i have exported a xy.dmp file from a database . when i am importing it to my
data base it is giving a error

1.open dos prompt
2.specify the following command ..
imp user/pwd file=a.dmp

then it is giving the following problem.

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

how can i give Dba privileges to a user ?
Jan 8 '08 #1
3 3896
8,127 Expert 4TB
that is because the account through which the file was exported was a DBA account not a normal user.

try to import from SYS or SYSTEM or anyother DBA account to the particular user schema.
Jan 8 '08 #2
thanks . its a great help
Feb 20 '08 #3
8,127 Expert 4TB
thanks . its a great help
You are most welcome.
Feb 21 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by hellprout | last post: by
11 posts views Thread by Jeff Wagner | last post: by
4 posts views Thread by dale cooper | last post: by
6 posts views Thread by Joolz | last post: by
5 posts views Thread by Mark A. Sam | last post: by
9 posts views Thread by Nick Locke | last post: by
3 posts views Thread by Mohamed Yousef | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.