Re: Space Report History

From: Michael Calisi <oracle455_at_gmail.com>
Date: Fri, 2 Jun 2017 10:47:18 -0400
Message-ID: <CAJkYCMEu=uA6xSg=VQdcvJgySMnfoBHBnoWxraw5h3EN6_rz4Q_at_mail.gmail.com>



This is what I was looking for.
select to_char(CREATION_TIME,'DD-MM-RRRR HH24:MM:SS'),name, bytes, ts# from v$datafile order by TS#;

On Sun, May 21, 2017 at 7:10 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:

> unless you offload this info to some schema/database where you control the
> retention, your only option I believe is to set the retention that far back
>
>
> Jack
>
> Jack van Zanen
>
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>
> On Wed, May 17, 2017 at 2:08 AM, Michael Calisi <oracle455_at_gmail.com>
> wrote:
>
>> I was trying to develop some tablespace history reports that would go
>> back a year plus. Is it true unless my AWR retention was set that far back
>> I am unable to retrieve this information?
>>
>> --
>> Michael A. Calisi
>>
>
>

-- 
Michael A. Calisi

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 02 2017 - 16:47:18 CEST

Original text of this message