在Oracle中的impdp.为什么不创建用户? [英] impdp in Oracle. Why it does not create users?

问题描述

我是oracle的新手，我正遇到impdp的麻烦.我有一个生产服务器，并且已经创建了用于测试目的的新服务器，因此我安装了centos，oracle并创建了数据库"sire".现在，我使用以下命令从生产服务器进行转储:

I am newbie in oracle and I am facing troubles with impdp. I have a production server and I have created a new server for testing purposes, so I installed centos, oracle and created the database "sire". Now I make a dump from the production server with the following command:

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

我来到新服务器，然后执行impdp:

The I come to the new server, and I execute impdp:

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

它开始进行导入，但是随后出现错误，例如:

It starts to do the import but then I receive errors such as:

用户vberrios不存在".还有错误，因为它不能 找到了一些架构和表空间.

"the user vberrios does not exist". And also error beause it cannot found some schemas and tablespaces.

我的问题是:不认为impdp full=Y必须导入所有用户和模式吗?我已经读到必须在目标服务器中创建用户，但是数据库中大约有300个用户.如何在空服务器中完全导入.我只想导入完整的数据库和用户以及所有对象.

My question is: It is not supposed that impdp full=Y must import all users and schemas? I have read that I have to create the users in the destination server but I have about 300 users in the database. How can I do a full import in a empty server. I just want to import the full database and user and all objects.

推荐答案

The documentation states, that impdp will create uses, when the dump file contains the create user statements:

如果您要重新映射的架构不存在，则导入 只要转储文件集包含 必要的CREATE USER元数据，并且您导入的数据足够 特权.

If the schema you are remapping to does not already exist, the import operation creates it, provided the dump file set contains the necessary CREATE USER metadata and you are importing with enough privileges.

因此您的转储文件不完整(例如，由于缺少特权)或目标数据库上没有特权.

So either your dump file is incomplete (for example due to missing privileges) or you are lacking privileges on the target database.

因此，请检查您对源数据库和目标数据库的特权.请根据相关信息更新您的问题.为了使导出包含模式定义，您必须具有DATAPUMP_EXP_FULL_DATABASE特权.

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

这篇关于在Oracle中的impdp.为什么不创建用户?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！