Re: Oracle Enterprise Manager

Scott Imlach wrote:
>
> I have need to migrate an export from a 7.3 database to an 8i database.
> From what I have been able to discern, the data import/export utility is now
> buried in the OEM so I went through the exercise of setting up the OEM
> environment choosing the defaults along the way.
>
> I now have the console up and running but the data export/import utility is
> nowhere to be found. The only administrative tools I have are the Security
> Manager, Schema Manager, Storage Manager, Instance Manager, and SQL
> Worksheet.
>
> I am working in a Windows 2000 environment. OEM is version 2.0.4.0.0.
> Database is 8.1.5.0.0
>
> The Enterprise Manager Server is evidently another security layer that
> enables DBA's to have a single OEM login mapped to specific logins of
> various databases throughout the enterprise.
>
> The OEM account I am using is the standard SYSMAN account and it is mapped
> to a user on my 8i database with CONNECT, RESOURCE, and DBA role. I have
> also assigned SYSDBA system priviledge to the 8i account as a straw grasping
> measure.
>
> So, where is the Import/Export Utility/Wizard? Any help would be
> appreciated,
>
> Scott
I don't know where this is in OEM, but imp/exp are in %ORACLE_HOME%\bin.

You should use the emp from your 8i Oracle Home to export from your v7 instance, and, of course, use the imp from this same Oracle Home to load your 8i instance.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.