Hi everyone,
I'm on internship and i've never work on DB before. I've searched many time on internet but i didn't find solution that work for the moment.
I'm on Windows XP 32bits, Oracle 11g (11.2.0.1.0)
I'm actually trying to import schemas from .dmp file with datapump on my local DB. My boss give me a .dmp file from his computer and i putted it in a folder (C:\datapump) on my computer.
I have already created "user" on my DB and a "datapump" folder on my DB to.
I tried: impdp user/password SCHEMA=schema_name DIRECTORY=datapump DUMPFILE=ext_file.dmp
And i have this errors:
ORA-39002: invalid operation
ORA-39070: unable to open the log file
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
Which stage did I miss? Did i forgot something to do before the import?
I don't know if I give you all information about my request so tell me if i forgot something.
Thanks, and sorry if I did some English mistakes !