cancel
Showing results for 
Search instead for 
Did you mean: 

History of multiple tables

Former Member
0 Kudos

Hi all,

We have a requirement where we need to find out history of multiple tables.Is there a way we can find out history for multiple tables.We have checked rstbhist but its only for one table and also db02.

Database : oracle

os : windows 2003 and ecc6.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

we need the sizes so rstbhist is ruled out we want the way it is displayed in db02 it fetches from moni but is there a way to retrieve multiple table sizes history.

Former Member
0 Kudos

Hello Ambarish,

Are you looking for history of table size or data changes?

If you are looking for size you can go to DB02 in that there is Space management. In space go to segments which gives option of using detailed analysis mention the table name in segments you should be able to see the details.

Regards

Vivek

Former Member
0 Kudos

Hello Ambarish,

> Are you looking for history of table size or data changes?

>

> If you are looking for size you can go to DB02 in that there is Space management. In space go to segments which gives option of using detailed analysis mention the table name in segments you should be able to see the details.

>

> Regards

> Vivek

In DB02 at a time we can mention only one table we want the same for multiple tables.That was my query.

Former Member
0 Kudos

Hi,

You can log the changes of data in a table (append, modification or delete fields) but it will slow down the accesses when you change the table as record have to be written into the log table for each change.

Go to Se11-Technical Settings- tick the log data changes

You just have the parameter rec/client set in system profile (RZ10)

Ex:- 1.rec/client = all (log all clients)

2.rec/client=<client> (log all specific clients)

3. rec/client=off (do not log)

You can see the changes to the table in the transaction OY18 or SCU3

Regards

Bhuban

RKFL

Former Member
0 Kudos

Hi,

I am looking for table history size which we obtain from db02.But the problem is that db02 we can maintain only one table.Thanks,.

Former Member
0 Kudos

Closing the thread but the issue has not been resolved.

Answers (0)