pardeshirahul
asked on
last time the tables we inported into an enviroment
How to find in Oracle
when was the last last time a Table was imported into an instance like PROD database
when was the last last time a Table was imported into an instance like PROD database
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AJ, a side question: would your answer be correct if the import replaced content of the tables instead of re-creating them?
dvz:
I have clearly stated my assumption - you may want to have a look again and interpret
I have clearly stated my assumption - you may want to have a look again and interpret
Aside from recreating the tables as part of the import process, are the tables static once imported? In other words, is DML performed on the tables after they have been imported?
If not, you can probably get a decent estimate using ORA_ROWSCN:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions142.htm
If not, you can probably get a decent estimate using ORA_ROWSCN:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions142.htm
Other supporting tables are DBA_OBJECTS and USER_OBJECTS