Re: user?

From: Marty Grinstead <MGrinstead_at_email.msn.com>
Date: Mon, 11 Oct 1999 21:36:07 -0400
Message-ID: <#bHx$TFF$GA.314@cpmsnbbsa03>

Verna,
You are correct. Those tables are the repository. Assuming you are using a version lower than 2.0.4, each user that logs into OEM will create a repository. The 'system' user will also create a repository, but that is a BAD idea. You don't want to cram a hundred tables in the system schema. That is a good way to corrupt the database.

Marty

Verna Legaspi wrote in message ...
>I'm pretty new, myself. However, I think those tables (and views) are
>created if you use OEM logged in as a user other than system. I believe
>that's the repository?
>
>Oracle pros... correct me if I'm wrong?
>
>Bill Portellie <bill_at_sysbase.com> wrote in message
>news:38003211.4D1C3E03_at_sysbase.com...
>> I am extremely new to oracle. In the installation of the oracle
>> enterprise manager you configure a database for yourself to use and set
>> the username. password etc. Once this is created and you view the schema
>> it has lots of tables in it starting with SMP_ etc. What are these for
>> and why are the in the schema?
>>
>> Thanks in advance
>>
>
>
Received on Mon Oct 11 1999 - 20:36:07 CDT