Re: error when importing dump imp-00058 ora-06550 pls-00302
- From: Guilherme Raymo Longo <grlongo.ireland@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 7 Dec 2010 17:51:17 -0200
Ok mates,
end of the day and the DBA just called to tell me the good news.
The erros was in the command I was issuing to import the db
I was issuing:
imp system/oracle@tcp file=f:\bkp.dmp log=f:\bkp_imp.log fromuser=tcp
touser=tcp tablespaces=dados
IMP SYSTEM/ORACLE FILE=f:\BKP.DMP FROMUSER=TCP TOUSER=TCP
LOG=f:\BKP_IMPORT.LOG BUFFER=100000
The only thing I had to remove was the tablespaces parameter. I found it
strange since I used to import with this command.
Well, problem solved!
On Mon, Dec 6, 2010 at 10:14 PM, Guilherme Raymo Longo <
grlongo.ireland@xxxxxxxxx> wrote:
> Hi mates,
>
> I am having a hard time with something that should be simple task.
> It's a error with the imp tool
>
> I have the following cenario:
>
> Source -> windows 2000 server / Oracle 9i / Client 9i
> Destination -> Windows 2008 server / Oracle 11g / Cliente 11g
>
> The error is the following:
>
> http://yfrog.com/75oraclep
>
> I thought i should export with a newer client so I tried with the 10g
> client as well but at this time even the export had the same behavior and
> thrown the error.
> I can do nothing anymore since I had to send the computer to a DBA to fix
> the problem, but it is killing me that a had no time to try it myself.
>
> Do you guys could you please gimme a hint why oracle is complaining??
>
> Regards.
>
Other related posts:
