OraFAQ Forum: Server Administration » Pooling meta data into new schema

Home » RDBMS Server » Server Administration » Pooling meta data into new schema (Linux Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Pooling meta data into new schema [message #555232]

Tue, 22 May 2012 09:49

sekharsomu
Messages: 72
Registered: December 2008

Member

Hi Guys,

I have created different scripts to monitor growth planning of the database my idea was generate a simple output file to a directory and create a report and send it as mail thru mail server.

but the client requested me to create new schema and population all the stats i have collected into the tables in this schema .

So can some one advise me on how to pool all the stats from different databases into this new schema efficiently

Thanks!

Report message to a moderator

Re: Pooling meta data into new schema [message #555233 is a reply to message #555232]

Tue, 22 May 2012 09:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

post CREATE TABLE statements for the "history" tables in the new schema

Report message to a moderator