Help - Search - Members - Calendar
Full Version: Auto Generated Oracle tables and packages in Database
Oracle DBA Forums > Oracle > Oracle Forum
Jyothi
Hi,

Can anyone please tell me the reason Why Oracle will generate its own tables and packages in to the database.

those tables were prefixed with "MD_" and Packages were wrapped... No idea why it has generated even i didnt find any answer when i ggogled it...

onething i can say here is, a day before this, we made

"Alter table MEDIA enable Row Movement;"

and the day night when these tables were generated, we disabled it.

Will this can cause ORACLE to generate its own tables and Packages...?

Please anyone help me to find out wat might be the reason for this....

Thanks.
dave
oracle didnt create its own, a dba installed the mdsys option in the database
Jyothi
QUOTE (dave @ Jul 21 2008, 04:59 PM) *
oracle didnt create its own, a dba installed the mdsys option in the database



Hi Dave,

Thanks for your reply, but will be more helpful if you can say in which scenario's it will generate these tables and Packages?

Thanks n Regards,
Jyothi.
dave
when someone runs the scripts which creates it

again, someone did this intentionally, not the database
HAL9000
"Can anyone please tell me the reason Why Oracle will generate its own tables and packages in to the database."

First., Oracle needs tables to hold metadata.

"even i didnt find any answer when i ggogled it... "

No surprise there, you can't even spell Google.
Jac
QUOTE (HAL9000 @ Jul 21 2008, 07:15 PM) *
"Can anyone please tell me the reason Why Oracle will generate its own tables and packages in to the database."

First., Oracle needs tables to hold metadata.

"even i didnt find any answer when i ggogled it... "

No surprise there, you can't even spell Google.


>> No surprise there, you can't even spell Google.

mad.gif

this needs attention of this very forum moderator; should a newbie be thrashed like this?

isn't it agaist the policy of this forum?

http://dba.ipbhost.com/index.php?showtopic=1449
dave
come on, grow a pair - seriously
HAL9000
Jac,

Sorry if you were offended, but your question can indeed be answered with a fast Google search of the Oracle docs.

http://www.google.com/search?&q=oracle...install+Spatial

Oracle spacial and InterMedia NEVER installs by itself!!

HOWEVER, THE "INSTALL ORACLE SPATIAL" option is checked in the installer.

I'll bet that is how it got there, you did not un-check the box:

http://download.oracle.com/docs/cd/B10501_.../sdo_migrat.htm

QUOTE
"When you install Oracle release 9.2.0, the option to install Spatial is preselected by default.

If you accept this default, you do not need to perform the installation steps described in this section, because the MDSYS user is already created and locked automatically."


Problem solved, eh?
Jyothi
QUOTE (HAL9000 @ Jul 21 2008, 10:11 PM) *
Jac,

Sorry if you were offended, but your question can indeed be answered with a fast Google search of the Oracle docs.

http://www.google.com/search?&q=oracle...install+Spatial

Oracle spacial and InterMedia NEVER installs by itself!!

HOWEVER, THE "INSTALL ORACLE SPATIAL" option is checked in the installer.

I'll bet that is how it got there, you did not un-check the box:

http://download.oracle.com/docs/cd/B10501_.../sdo_migrat.htm
Problem solved, eh?


Thank you for a solution, but question is the whole database is newly installed n setup before 4 or 5 months, and all of a sudden why it has generated.. these tables now... means" Just want to know for any specific reason or if we run any queries related to ROW MOVEMENT for table will cause this to happen ? ".
dave
QUOTE (Jyothi @ Jul 22 2008, 08:15 AM) *
Thank you for a solution, but question is the whole database is newly installed n setup before 4 or 5 months, and all of a sudden why it has generated.. these tables now... means" Just want to know for any specific reason or if we run any queries related to ROW MOVEMENT for table will cause this to happen ? ".


MY GOD!

For the last time, SOMEONE RAN THE SCRIPTS TO CREATE IT, A REAL PERSON, SOMEONE WHO HAS ACCESS TO THE DATABASE DID IT.
Jyothi
QUOTE (dave @ Jul 22 2008, 02:02 PM) *
MY GOD!

For the last time, SOMEONE RAN THE SCRIPTS TO CREATE IT, A REAL PERSON, SOMEONE WHO HAS ACCESS TO THE DATABASE DID IT.



Hi dave,

can you tell me what type of scripts can generate these.

Tables around 30 prefixed as"MD_" are added into database and packages were wrapped (MD_META, MIGRATION, MIGRATION_TRANSFORMER).

Thanks,
Jyothi.
Asad
i think oracle migration workbench & oracle sql developer uses these objects to hold metadata while migrating thirdparty object in oracle.

you can find some more info on these objects of repository here:

http://www.oracle.com/technology/oramag/or...sep/o57sql.html

also have a look on metalink bug# 7013320 related to these objects.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.