Re: exp error

Many thanks Suzy,

   Yes, when I use USERID=user/pass_at_db_name it works!

Ben

• Suzy Vordos <lvordos_at_uswest.com> wrote:
  >
  > -- Check the value of ORACLE_SID, is it set to the
  > correct SID?
  > -- Check if TWO_TASK is set... if so, is the value
  > set to the correct
  > SID?
  > -- You might try USERID=user/pass_at_db_name (if w/o
  > @db_name the default
  > is ORACLE_SID)
  >
  > Kader Ben wrote:
  > >
  > > Hi listers,
  > >
  > > When I tried to export table, I ran into the
  > > error:
  > >
  > > EXP-00056: ORACLE error 1017 encountered
  > > ORA-01017: invalid username/password; logon denied
  > > EXP-00222:
  > > System error message 22
  > > EXP-00005: all allowable logon attempts failed
  > > EXP-00000: Export terminated unsuccessfully
  > >
  > > The user name and password is correct and I can
  > logon
  > > the DB. I ran into the same error even with
  > > system/password user. Please advise how to fix
  > this
  > > problem.
  > >
  > > Kader
  > >
  > >
  > > __________________________________________________
  > > Do You Yahoo!?
  > > Yahoo! Photos -- now, 100 FREE prints!
  > > http://photos.yahoo.com
  > > --
  > > Author: Kader Ben
  > > INET: kaderb_at_yahoo.com
  > >
  > > Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > > San Diego, California -- Public Internet
  > access / Mailing Lists
  > >
  >

  ---

  
  > > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > > (or the name of mailing list you want to be
  > removed from). You may
  > > also send the HELP command for other information
  > (like subscribing).
  > --
  > Author: Suzy Vordos
  > INET: lvordos_at_uswest.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---