Creating a DR database using export and import.
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,
0