archives

Date
  • 01
  • 02
  • 03
  • 04
  • 05
  • 06
  • 07
  • 08
  • 09
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31

Oracle exp (and other utilities) Without TNSNAMES

It is possible to run the Oracle exp or imp (and probably other commands) without getting your tnsnames.ora and your environment variables 100% right.  (You will need them at least part-way right.) Here's how to run exp:

exp userid/password@sidname direct=y recordlength=65535 feedback=1000 file=test1.dmp log=test1.log tables=(TABLENAME)

Note: sidname might be globalname instead; I'm not sure.