It seems when doing exp, oracle (at least 10gR2) only looks for the first character of DIRECT parameter. For example, exp user/passwd direct=YN exp user/passwd direct=NY exp user/passwd direct=Y111 exp user/passwd direct=N111 all are working. I would not expect that based on what I get from exp help=y Any comments? Guang Mei www.eversave.com