OraFAQ Forum: Server Administration » how to find last Import date?

Home » RDBMS Server » Server Administration » how to find last Import date?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find last Import date? [message #180860]

Wed, 05 July 2006 09:40

ozzy80
Messages: 55
Registered: June 2005

Member

Is there any table/view where I could get the info about when was the database last refreshed/imported.

We have a test environment, and I want to know when it was last imported with the prod data.

Thanx for your help!

Ozzy

Report message to a moderator

Re: how to find last Import date? [message #180863 is a reply to message #180860]

Wed, 05 July 2006 10:05

orausern
Messages: 826
Registered: December 2005

Senior Member

I think one way to approach this is to see the value of CREATED column of the tables..if they were imported, then around the same time they would be created. that can give a pointer.

Report message to a moderator

Re: how to find last Import date? [message #180867 is a reply to message #180863]

Wed, 05 July 2006 10:15

ozzy80
Messages: 55
Registered: June 2005

Member

Okay, let me look at that. Thanx!

Report message to a moderator

Previous Topic:	monitoring Oracle database
Next Topic:	How to copy encrypted data between 2 databases?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 15:27:17 CST 2025