Home » RDBMS Server » Server Administration » import gets unknown command error
import gets unknown command error [message #372724] Mon, 05 March 2001 12:51 Go to next message
amber
Messages: 4
Registered: March 2001
Junior Member
I am trying to import a dump file from an Oracle 8i db version 8.1.5.0.0 on a solaris platform into a different Oracle instance of the same version. It was created with buffers=8000000 file=pamsstats.dmp owner=pams statistics=estimate log=pamsstats.log rows=n. I try the command in sqlplus:
SQL> import file=pamsstats.dmp analyze=n log=pams.log and I get the following error message:
SP2-0042: unknown command "import fil..." - rest of line ignored.
The same thing happens when I use imp instead of import. What am I doing wrong?

Thanks in advance,
Amber
Re: import gets unknown command error [message #372725 is a reply to message #372724] Mon, 05 March 2001 17:41 Go to previous messageGo to next message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
imp and exp are separate programs from sqlplus. run imp from the O/S prompt

imp help=y (for help)
Re: import gets unknown command error [message #372726 is a reply to message #372725] Mon, 05 March 2001 19:34 Go to previous message
amber
Messages: 4
Registered: March 2001
Junior Member
Thank you! I knew it was something so fundamental that no one had bothered to put it on their how-tos. Thanks, Amber
Previous Topic: Regarding Check constraint in Date field
Next Topic: Object REFs
Goto Forum:
  


Current Time: Mon Jun 10 20:09:33 CDT 2024