Re: imp full=y

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 07 Dec 2005 21:14:24 +0100
Message-ID: <dn7f7n$89k$1@news6.zwoll1.ov.home.nl>

RogBaker_at_gmail.com wrote:
> I am making a copy of a 8.1.7 database to test an upgrade on. I
> installed oracle 8.1.7 on the new server, created a shell database,
> created my tablespaces, then did a full import from the source
> database. Do I need to worry about any SYSTEM table rows that DID or
> DID NOT import? I'm thinking that I should not have imported any SYSTEM
> tables.
>

Depends....

on the user that did the export (assuming full=y). If SYSTEM, yes - you will have SYSTEM tables, or rows, if the tables did not exists, or if the rows were not prevented from loading via a primary key mechanism. Your import log can shed a light on that.

Other than that, using the SYSTEM account for anything else that day-to-day operations is a Bad Idea (tm). So, it should not have (read: hardly have) any tables.

If it is an application upgrade, you are testing, why not just import the owner of the application schema?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Dec 07 2005 - 14:14:24 CST