Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
list of tables created by enterprise manager
162 views
Skip to first unread message
anurag
May 10, 2000, 3:00:00 AM5/10/00
to
Hi,
From where do I get a list of tables created by enterprise
manager. I want to drop them as they are created in my user
tablesppace. I want to put them under tools tablespace.
From where do I get a list of tables created by enterprise
manager. I want to drop them as they are created in my user
tablesppace. I want to put them under tools tablespace.
Thanks
Anurag
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
NeilC
May 11, 2000, 3:00:00 AM5/11/00
to
Hi anurag,
the tables can vary between version, so it would help if you quoted the
relevant version / platform etc.
But why not just export the repository user, drop the user (or delete
the tables produced by the output of the export) then re-import
(cr-createing the user if dropped and ensuring the relevant default
tablespace and tablespace quotas are set)
HTH
Neil
Van Messner
May 11, 2000, 3:00:00 AM5/11/00
to
If you set up an OEM administrator (sysman) they will be objects
owned by sysman. If not you will have to look for tables
starting with VDK VBZ$ SMP EPC, sequences starting with VDK VBZ$
SMP EPC, packages starting with SMP. There are also triggers,
indexes and views - about 540 objects altogether,
owned by sysman. If not you will have to look for tables
starting with VDK VBZ$ SMP EPC, sequences starting with VDK VBZ$
SMP EPC, packages starting with SMP. There are also triggers,
indexes and views - about 540 objects altogether,
Unfortunately, I can't be sure that all objects starting with
those letters belong only to OEM. You may have to call Oracle.
Van
0 new messages