On 3/21/06, Tricia McKellar <tkm.lists_at_gmail.com> wrote:
>
> Hello,
>
> I'm new to oracle dba responsibilities and in need of some direction.
> I need to implement a process and I'm not sure which technologies
> and/or processes I should investigate.
>
> Our application produces a set of reporting views in the production
> database (solaris, oracle 9.2). My managers and others are anxious to
> run reports on the data; I've created a report user and throttled
> resources for this user, but my goal is to restrict all
> non-application access to the production database. I would like to
> automate the copy the reporting data to a dedicated report database on
> another host, preferably daily.
>
> Can you give me some direction on the technologies/processes to copy
> these tables to another database I might investigate? We cannot
> shutdown the production database daily. We do use rman to disk, but
> do not have rman set up with a media manager yet. One of my books
> mentions "transportable tablespaces"--should I read up on that?
> Should I do some homework on export/import? One of the reporting views
> could contain millions of rows, but the other dozen or so tables are
> comparatively small (thousands of rows).
>
> Thank you for any guidance!
>
> --Tricia
>
> Tricia McKellar
> Operations & Systems Analyst
> NC State University
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
I will try this, create new role than assign a new user then create database
link with the user.
On the other database
create table as select * from table_at_productiondb
generate report
--
regards,
Sinardy
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 20 2006 - 20:35:36 CST
