Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXPDP and IMPDP from existing database to new 'scratch' database

MSandicoApr 19 2013 — edited Apr 20 2013

Hi All,

THis is the first time i'm trying to export and import (using datapump) from one database into a brand spanking new database.

Source/Target OS - WIndows 2008 R2 Standard
Source/Target - Oracle 11G Release 2 (same patch updates - 11.2.0.3.3)

I took a full expd of the source database.

I created the same directory structure on the target as the source. I created an empty database on the target server with the same name as the source.

I am trying to use impdp to import this full export into the target database, with the end goal being everything is the same on the target as it is on the source (users, tablespaces, data, schemas, etc...).

I am running into some errors (object already exists, a few others to mention). But my question is, is this a proper way of copying a database from one server to a new server?

Thanks in advance