on 01-07-2009 12:11 PM
Hello,
I would like to extract 25 largest tables from SAP (not logging on to DB). How can I get a list of these tables? Using which options from DB02 can this info be extracted? Please guide.
Regards,
Atul Lotlikar.
tcode: DB02OLD
click on "Detailed Analysis"
"Object type" TABLE
"Size / kbyte >" 1000000 (1 million)
click on "Green check"
under the KBytes colum, click on the first entry.
Press F8
There ya go, you have the biggest tables in your database.
note that this does not include indexes and does not summarize partitioned tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Atul,
Another way to get this is to login to your server and run the ABAP report ->RSORA085
This will give you a complete analysis of your database with the size of the tables , everything...
regards,
hemanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.