Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL for comparing OLTP vs OLAP -(Source-OLTP) and Target-OLAP

Posted on 2008-10-21
3
Medium Priority
?
1,082 Views
Last Modified: 2013-12-18
I am trying to write a SQL query to compare two databases OLTP and OLAP to get the table counts eg:
we have table name W_ACT in OLAP database where count is 2500, we need to see what is the count for same table in OLTP(S_ACT).we have a long list of table counts I was wondering if some one could help me in genrating those counts all at once.

Thanks
Mein
0
Comment
Question by:MEINKIYAKAROON
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
dbmullen earned 500 total points
ID: 22781609
analyze the tables in both databases and query the catalog


insert into some_table
select
  (select instance_name from v$instance) db_name,
table_name, num_rows, sysdate from dba_tables@oltp
;
commit;

insert into some_table
select
  (select instance_name from v$instance) db_name,
table_name, num_rows, sysdate from dba_tables@olap
;
commit;


0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question