on 07-07-2011 4:16 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.