|
|
|
|
|
|
|
|
|
|
|
|
| Re: date of database refresh [message #293072 is a reply to message #293071] |
Thu, 10 January 2008 15:40   |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
Then get a new DBA!
It is YOUR data & YOUR procedures.
Surely you can find a date field in some table that gets the "current" timestamp.
What is the MAX value of it?
You know, this is not the first time when you jump to answer my questions in this rude manner. Maybe you have nothing beter to do, I dont know. I consider this forum to be very beneficial where professional people can share their experience. "If you dont know, go ask", etc. I dont think that is nice and is sure enough not professional. I DONT know, so I asked. Isn't it what this forum intented for - asking when you dont know? So please, pretty please, with a sugar on top, if you dont have anything useful to contribute, dont answer my posts.
|
|
|
|
| Re: date of database refresh [message #293077 is a reply to message #293072] |
Thu, 10 January 2008 16:26 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> I need to know if there is a way to find out the date when this took place.
Before you start assuming things,
your post does not really help us to help you.
You have never mentioned how the "refresh" is done.
First you said,
>> when a particular instance was last refreshed?
Then
>>refresh of test database from production schema.
Fact is,
If you used RMAN to do a clone (people call it refresh), the whole database is recreated. You can check v$database.
If you would used export and import, tables/indexes might have been recreated and you can check user_objects.
But again, you DBA might have kept the tables and only purged the data and could have reloaded only the data. Table creation timestamps will not change.
To add with, no version information or any other useful information is provided for us to guess any more.
IMHO, after 100 plus postings, you are no more a newbie here and supposed to know how to ask a question.
If you look close, whatever i said above in several sentences, Anacedent has succinctly put in one line.
| Quote: |
It is YOUR data & YOUR procedures.
|
and went further to give you another solution (checking for a timestamp column in your custom table).
|
|
|
|
| Re: date of database refresh [message #293262 is a reply to message #293077] |
Fri, 11 January 2008 08:37 |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
I saw your reply yesterday and noticed that you edited your post from :
| Quote: |
and I went further to give you another solution (checking for a timestamp column in your custom table).
|
to:
| Quote: |
If you look close, whatever i said above in several sentences, Anacedent has succinctly put in one line.
|
I think you and anacent are the same person, but frankly I dont care. The first rule in Orafaq Forum Guide calls for users to be polite, which for some reason you have problems doing when it comes to my posts. I asked a question because I needed this answer. It is you who assumed that we have a dumb dba and that I am a developer who does not know my data. I am not a developer and the dba for this particular system has abruptly left, leaving me to figure out who should be locked out of this db, what objects do not need to be there, etc. So there, it is you who assumed.
|
|
|
|
|
|
| Re: date of database refresh [message #293266 is a reply to message #293262] |
Fri, 11 January 2008 08:52 |
|
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> I saw your reply yesterday and noticed that you edited your post from
None Edited the posts.
If I did edit my posts, you will see it here, as in this message.
>>I think you and anacent are the same person,
That's very very funny.
[Updated on: Fri, 11 January 2008 08:54] Report message to a moderator |
|
|
|
| Re: date of database refresh [message #293271 is a reply to message #293265] |
Fri, 11 January 2008 09:09 |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
|
I am not going to waiste my time quoting you back and forth. You know what you said. The post looks differenet from the way it did yesterday, hence, it was edited. You are a moderator, but your people skills are at zero. Anyway, life is too beautiful and short (plus I am very busy) to spend it on arguing, have a wonderful day, I will figure out my girly problem myself. ciao.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
