Database Utilities (MOSC)

MOSC Banner

Creating a DR database using export and import.

edited Nov 20, 2009 7:15AM in Database Utilities (MOSC) 7 commentsAnswered
 I created a DR database using an full export of the production database and creating a new instance in a remote location and imported selected user schemas for DR.   The imports where successful, but I have noticed in the DR database that I have to fully qualify table names when I access tables, even when I am logged in as sys or connect internal.  This is an Oracle 8.1.7 database.

Any ideas on why this is happening in the DR database, but not in the original production database.

Thanks,

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