• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

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
1 Solution
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.

Join & Write a Comment

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now