Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01917 ERROR
ORA-01917 ERROR [message #654991] Thu, 18 August 2016 06:05 Go to next message
mfahimaamirgmailcom
Messages: 62
Registered: May 2011
Location: pakistan
Member
sir i try to get backup by export / import and give read and write right to HR user but oracle give me error ora-00990
see all command in attachment picture also
see command

login / as sysdba

sql> grant read, write on directory orcl_full to hr;

ORA-01917 USER OR ROLE 'HR' NOES NOT EXIST

system give me error ORA - 01917

HOW I EXPORT AND IMPORT DATA
PLEASE HELP ME REGARD

/forum/fa/13232/0/


[mod-edit: imaged inserted into message body by bb]

[Updated on: Thu, 18 August 2016 15:23] by Moderator

Report message to a moderator

Re: ORA-01917 ERROR [message #654992 is a reply to message #654991] Thu, 18 August 2016 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The image shows you did not execute the statement you posted but another.
This one does obviously returns an error, SQL*Plus itself points to the error.
This is why we told you to ALWAYS copy and paste what you do and get and NOT tell us what you THINK you do and get.
And you don't need to post an image for text, just copy and paste it.
If you don't know how to do it, Google for "how to copy text from DOS box".

Re: ORA-01917 ERROR [message #654993 is a reply to message #654992] Thu, 18 August 2016 06:11 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also review your previous topics and feedback and thank people who took time to help you.

Previous Topic: How to get a value that has never been updated
Next Topic: Dynamic SQL Learning
Goto Forum:
  


Current Time: Thu Mar 28 09:45:07 CDT 2024