asked on 11/8/2018

script to compare number of lines on all tables between two schémas

Hello,

I search a script to compare number of lines on all tables between two schémas.

Thank you

Best regards

Oracle Database

Last Comment

slightwv (䄆 Netminder)

11/8/2018

slightwv (䄆 Netminder)

11/8/2018

What do you mean by "number of lines"? Do you mean number of rows?

slightwv (䄆 Netminder)

11/8/2018

If you mean number of rows, you can use the SQL here:
https://www.experts-exchange.com/questions/24170132/List-tables-with-count-of-rows-in-Oracle-database.html?anchorAnswerId=23716743#a23716743

Just run it for each schema and diff the results.

johnsone

11/8/2018

Are your statistics up to date? If they are, the dictionary is an easy way to check.

SELECT owner1.table_name, 
       owner1.table, 
       owner1.num_rows, 
       owner2.num_rows 
FROM   dba_tables owner1 
       join dba_tables owner2 
         ON owner1.table_name = owner2.table_name 
WHERE  owner1.owner = 'USER1' 
       AND owner2.owner = 'USER2';

Open in new window

I just typed that free hand and didn't try it, but it should be close.

bibi92

11/8/2018

ASKER

Hello,

I mean number of rows. I try already the post of slightwv but the result is not correct formatted.

Thank you

Best regards

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

11/8/2018

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial