Oracle Import Data dump: tablespace: "USERS" already exist

I am trying to import data using impdp in oracle. However, when I tried to import it, it is giving me the following error:

ORA-29349: tablespace "USERS" already exists

Since USERS is the defualt permenant tablespace that contains users objects, I tried to exclude it from the command by adding "exclude=tablespace:\" IN ('USERS')\""

However, adding that does not help at all as the error remains.

my command looks like following: "impdp SYSTEM/MYPASSWORD@orcl full=Y DIRECTORY=dir dumpfile=mydump.dmp LOGFILE=mydump.dmp.log exclude=tablespace:\" IN ('USERS')\" transport_datafiles='/path/to/file"

Any help is appreciated



Read more here: https://stackoverflow.com/questions/66267650/oracle-import-data-dump-tablespace-users-already-exist

Content Attribution

This content was originally published by AngryOtter at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: