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
Who is Participating?
ajexpertConnect With a Mentor Commented:
Was this table created and data was imported at the same time? If yes, you can use all_objects view to find out the created date

select CREATED from all_objects
where object_name = <YOUR TABLE NAME IN UPPER CASE>
DavidSenior Oracle Database AdministratorCommented:
AJ, a side question:  would your answer be correct if the import replaced content of the tables instead of re-creating them?

I have clearly stated my assumption - you may want to have a look again and interpret
slightwv (䄆 Netminder) Commented:
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:
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Other supporting tables are DBA_OBJECTS and USER_OBJECTS
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.