Oracle 11g. Failed to import dump files, even if the schema was created

Question

I created a user in Oracle 11gR2 using the following script

create user cata identified by cata default tablespace tbs temporary tablespace temp; grant DBA to cata; 

After trying to import a dump file using the command

 impdp system/ password@ORCL11 schemas=cata dumpfile=cata.dmp logfile=log.txt 

I get the following error

ORA-39002: Invalid operation ORA-39165: Schema ATGDB_CATA not found.

Surprisingly, when I try to export a dump from the same scheme, I can do it. So, if the schema was not created properly, I also could not export the dump file, right?

I also checked dba_users and created a schema. Is there anything else I can do to solve this problem.

Answer 1

From the error message, I assume that the original schema name was "atgdb_cata".

As you are now trying to import into a schema named "cata", you need to specify the remap_schema parameter

So, for your case: impdp system/ password@ORCL11 schemas=atgdb_cata dumpfile=cata.dmp logfile=log.txt remap_schema=atgdb_cata:cata

Answer 2

Provide the read and write roles in the Directory in which you created the new user: EX:

 GRANT READ, WRITE ON DIRECTORY dir_name TO NEW_USER: 

Also provide the following role to the new user:

 GRANT IMP_FULL_DATABASE TO NEW_USER; 

Thanks! NC

Answer 3

ORA-39002: Invalid operation ORA-39070: Cannot open the log file. ORA-29283: invalid file operation ORA-06512: in line "SYS.UTL_FILE", line 536 ORA-29283: invalid file operation

SOLUTION: create or replace the test_ dir directory as "FOLDER_NAME";

that 'FOLDER_NAME' must have this dump file

step: 1 create a SAMPLE folder under orcle_installed_path / sql / SAMPLE put this dump file in this SAMPLE folder.

Go to the basket and follow. / sqlplus and SQL login> create or replace the test_ dir directory with 'SAMPLE';

SQL> SQL> GRANT READ, WRITE in the test_dir directory in 'USER';

SQL> GRANT IMP_FULL_DATABASE in 'USER'; The output is then impdb to import this dump