Error ORACLE-Export utility on LTO (failed open .. for write)

[Salvador Reyna]

Hello all,

Exporting a table un Oracle 8i I have the following error:
EXP-00028: failed to open /dev/rmt/3mn/file.dmp for write

If I make a:
mt -f /dev/rmt/3mn rew
Works correctly

Thanks in advance.

[Peter Godron · Accepted solution]

Salvador,
have you had a look at:
http://www.orafaq.com/forum/t/36963/0/

[Eric Antunes]

Hi Salvador,

Why do you use /dev/rmt/3mn? Why not /dev/rmt/3m? /dev/rmt/3mn is saying to tape to not rewind (the "n" after the "m" means "No rewind") and this is why it works after "mt -f /dev/rmt/3mn rew"...

Check your tape options with:

#ioscan -fnCtape

And use a tape device option with Rewind for the export (/dev/rmt/3m for example).

Best Regards,

Eric Antunes