EXP gives error 12560 and I don't know what to do about it
510146May 30 2006 — edited May 31 2006Hi,
Context: I've been parachuted to an ORACLE DBA position from an SQL Server DBA position.
What I want to do : Export a schema/user so that I can import to another database.
How I went about it : I read that by using the EXP utility one can export the schema to a binary file that can then be used by the IMP utility to re-create the schema on another server. I have a local server (for familiarization purposes) on my workstation.
I used the following commands :
SET ORACLE_SID=BOUBOU
EXP USERID=SCOTT/TEST
This worked fine.
I tried doing the same on the the development server (I changed the SID to the one appropriate for our development instance) and I get error ORACLE 12560. However, I can connect to the development instance with SQLPLUS from the same workstation with user (scott)
Can anyone help ... please...
Thanks,
Gabriel