Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2016
    Posts
    1

    Unanswered: ora-01917 user or role 'mdamfa' does not exist

    dear i want to export data and i try with below code but error ora-01917 create problem for me

    / AS SYSDBA


    SQL> CREATE OR REPLACE DIRECTORY testdir AS 'E:\fulldata\';
    directory TESTDATA created.

    SQL> GRANT READ, WRITE ON DIRECTORY testdir TO mdamfa;

    ora-01917 user or role 'mdamfa' does not exist

    dear again system give me this error

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Isn't it obvoius? There's no user named MDAMFA in your database.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    type

    select *
    from dba_users
    where username = 'MDAMFA';
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Or, possibly even better
    Code:
    select *
    from dba_users
    where upper(username) = 'MDAMFA'

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Mdamfa, when you ran myine or Littlefoot's script what happened?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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