Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • 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
0
pardeshirahul
Asked:
pardeshirahul
1 Solution
 
ajexpertCommented:
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>
0
 
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?
0
 
ajexpertCommented:
dvz:

I have clearly stated my assumption - you may want to have a look again and interpret
0
 
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:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions142.htm
0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Other supporting tables are DBA_OBJECTS and USER_OBJECTS
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

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