Database Backup and Recovery (MOSC)

MOSC Banner

Import/Export questions

edited Mar 13, 2009 2:35AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
I need to do a quick refresh of a new 11g database.  Due to time constraints, I won’t have time to figure-out an RMAN solution.  The problem is further complicated as I am going from a non-ASM 10g database to a 11g database using ASM.  This appears to preclude me from using the TTS feature of the datapump.  Here is my question.  A full import of an exp dump file corrupts my EM config.  So I plan to import by schema name instead with the exception of schemas related to the SYSTEM or SYSAUX tablespace.  Also, if I import into a previously poplulated database, will I get duplicate records?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center