Which tables will be exported incremental

[Zahier]

Hi Techies,

I'm trying to find out which tables will be exported with my next incremental export. If I knew, then I could estimate how big the export will be, right? Could I do an incremental export with ROWS=N to first identify the tables? Surely Oracle stores the flag for which table will be exported in a system table somewhere. I could maybe pull the list from this table?

Any ideas?

 

[Turkbear]

Hi,
Check the table SYS.INCEXP - It tracks what has changed since the last incremental ( and maybe cumulative) export.

Http://tahiti.oracle.com

has nice docs on this in the v8i Utilities manual.





To Paraphrase:"The Help you get is proportional to the Help you give.."