This forum is currently locked. You can't register or post questions at this time. (read more)

how to know iot overflow tables between two db instances

All posts relating to Oracle database administration.

Moderator: Tim...

kytemaniac
Senior Member
Posts: 234
Joined: Tue May 19, 2009 12:59 am

how to know iot overflow tables between two db instances

Postby kytemaniac » Fri Mar 08, 2013 3:40 am

Code: Select all

select table_name from user_tables where iot_type='IOT_OVERFLOW' minus
select table_name from user_tables@hellasDB4 where iot_type='IOT_OVERFLOW';


Code: Select all

SYS_IOT_OVER_54968
SYS_IOT_OVER_54990


but the result above left me pondering what is the iot tables that is the first db instance but not the second db instance.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: how to know iot overflow tables between two db instances

Postby Tim... » Fri Mar 08, 2013 11:19 am

Hi.

Struggling to understand the question.

DB1 MINUS DB2 = Rows in DB1 that are not present in DB2
DB2 MINUS DB1 = Rows in DB2 that are not present in DB1

Does that answer your question? :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 8 guests

cron