Impdp in Oracle. Why is he not creating users?

Question

I am new to oracle and I ran into problems with impdp . I have a production server and I created a new server for testing, so I installed centos, oracle and created the "sire" database. Now I am dumping from the production server with the following command:

 expdp system/ password@sire full=Y directory=pump_dir dumpfile=sire_dump.dmp logfile=sire.log 

I am coming to a new server and I am doing impdp:

  impdp system/ password@sire full=Y directory=pump_directorio dumpfile=sire_dump.dmp logfile=sire_imp.log 

It starts to import, but then I get errors like:

"custom vberrios do not exist." And also a mistake, because she could not find some schemas and table spaces.

My question is: is it not supposed that impdp full=Y should import all users and schemas? I read that I need to create users on the target server, but I have about 300 users in the database. How can I do a full import on an empty server. I just want to import the full database, user and all objects.

Answer 1

The documentation states that impdp will create applications when the dump file contains instructions for the user:

If the schema you are reassigning does not yet exist, the import operation creates it if the dump file set contains the necessary CREATE USER metadata, and you import enough privileges.

Thus, either your dump file is incomplete (for example, due to the lack of privileges), or you do not have enough privileges in the target database.

So, check your privileges both on the source database and on the target database. Please clarify your question and then according to the information. For an export to include schema definitions, you must have the DATAPUMP_EXP_FULL_DATABASE privilege.