使用impdp导入期间现有表会发生什么 [英] What happens to existing tables during import using impdp

问题描述

我想从Prod导出和导入整个架构，但是Dev已经存在我不想受到影响的表(Prod中不存在).

I want to export and import an entire schema from Prod to Dev, but Dev has already existing tables (that are not there in Prod) which I don't want to be affected.

所以，问题是在导入(impdp)期间那些现有表会如何处理?

So, the question is during import (impdp) what happens to those existing tables?

谢谢.

推荐答案

如果您已备份完整数据库(包括创建数据库并在备份中创建表查询)，则会发生错误.

if you have backuped full database including create database and create tables queries in backup then there occurs error.

要解决该问题，您需要删除打算创建数据库和新表的每一行.

To solve the problem you needs to remove each line that is intented to create database and new table.

如果仅转储了数据，数据将被正确添加到现有表中. (如果不包含语法错误)

if you have dumped data only data is added to existing table with no errors. (if contains no syntax error)

如果您不需要开发数据库中的数据，然后登录数据库服务器并删除prod中的所有表，然后导入数据库文件.

if You don't need data in dev database Then login to database server and delete all tables that are in prod and then import your database file.

如果您不想删除开发数据库中的数据，然后创建与该数据库完全不同的数据库导入文件并修改您的连接字符串.

if You don't want to delete data in dev database Then create entirely different database import file to that database and modify your connection string.

这篇关于使用impdp导入期间现有表会发生什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！