Commands unavailable: SQLLOAD / IMP / EXP


I am trying to populate a database and find that several commands are not available from SQL*PLUS.

These include SQLLOAD, EXP and IMP (error msg: 'enknown command').

I managed to get round the problem by IMPorting my data in Enterprise Manager but now I really do need to use SQLLOAD and I am not sure what is causing the problem.

Maybe it's a permission's issue? I am trying to do this with a user who has DBA permissions and IMP/EXP permissions but maybe that isn't enough? Should I be logged in as SYS or SYSTEM?

All other commands (e.g. CREATE, DROP, etc) seem to work fine with that configuration.

I hope that someone can point me in the right direction.

Many thanks,
Alan Searle

PS: I also tried connecting an external table (delimetted in ascii format) but the command 'fell over' at ORGANISATION EXTERNAL (error msg: Missing or invalid option). I imagine this is caused by the same problem as with SQLLOAD.
.

Relevant Pages

  • Re: How do I create a new emkey for Enterprise Manager Database Control?
    ... How do I create a new emkey for Enterprise Manager Database Control? ... reinstalled the repository with these commands: ...
    (comp.databases.oracle.server)
  • Re: Commands unavailable: SQLLOAD / IMP / EXP
    ... | I am trying to populate a database and find that several commands are ... | These include SQLLOAD, EXP and IMP ... | has DBA permissions and IMP/EXP permissions but maybe that isn't enough? ... exp and sqlldr are OS programs and not SQL*Plus commands. ...
    (comp.databases.oracle.misc)
  • Re: Commands unavailable: SQLLOAD / IMP / EXP
    ... | I am trying to populate a database and find that several commands are | not available from SQL*PLUS. ... | These include SQLLOAD, EXP and IMP ... | I managed to get round the problem by IMPorting my data in Enterprise | Manager but now I really do need to use SQLLOAD and I am not sure what | is causing the problem. ... I am trying to do this with a user who | has DBA permissions and IMP/EXP permissions but maybe that isn't enough? ...
    (comp.databases.oracle.misc)
  • Re: OSQL vs Enterprise Manager
    ... With OSQL you can do all the TSQL commands, but you have to type in your ... where as in Enterprise manager you could do all the tasks by mouse ... We can not say any pros and cons...between both of them ...
    (microsoft.public.sqlserver.msde)