Imp - to update testing base

[diogoalvez]

Dear colleagues, good afternoon.

I am facing difficulties to update my test base, I describe below the steps that were performed:

01 - I copied the last backup (.dmp) production base 'pharma';

02 - Through the command below I tried to realize:

Select all

imp tek_555/tecnisa file=teknisa.2014-03-12.dmp fromuser=pharma touser=tek_555 buffer=5000000 ignore=y analyze=n commit=n log=teknisa.2014-03-12.log

However, the error is generated: [[1 ]

Environment information:
* Oracle version: Oracle 10g
* Operating system: Red Hat Enterprise Linux Server Release 5.3 (Tikanga)

I am a beginner in Oracle, and yet such a task had been designated to me, after leaving the Bank.

[adrianoturbo]

Brother, see if that way helps you:

Select all

 
imp tek_555/tecnisa@NOMEDOSEUBANCO FILE=teknisa.2014-03-12.dmp fromuser=pharma touser=tek_555;