Getting ORA-01031 Error at the time of export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Getting ORA-01031 Error at the time of export

  1. #1
    Join Date
    Jan 2008
    Posts
    39

    Getting ORA-01031 Error at the time of export

    Hello All,

    i am using below command to export user called 'Prashant' in Oracle 8.1.6

    Host exp userid='sys/sys as sysdba' owner=prashant file=d:\backup\prashant.dmp log=d:\backup\prashant.log

    At the time of Exporting Schema, it gives me error ORA-01031 Insufficient Priviledges

    Can any one help me how to resolve this error???

    Thanks
    Prashant

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    your OS user id doesnt have priveleges to connect as sysdba

  3. #3
    Join Date
    Jan 2008
    Posts
    39
    then wt steps should i have to follow?

    I mean wt should i have to do for giving priveleges to os user...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width