on 09-13-2008 2:44 AM
Hi Gurus ~
Could you tell me where I could find a list of tablespace tables for Netweaver 2004, ECC 6, and 4.7? Also, would you also include the general purpose of each of each of those tables?
Of course,<removed_by_moderator>
Read the "Rules of Engagement"
Thank you,
Denny Mathews.
Edited by: Juan Reyes on Sep 13, 2008 6:21 PM
hi
you can check all the table spaces in transaction db02.here you can check all the table spaces and their fill level.basically what ever entry you make or changes you do will be stored in tables which will in return will stored in table spaces.indexes are meant for direct read or sequential read of contents from database.you can also reorganize the tables or the whole table space in order to regain space of your database or for faster performance of database.
regards
subhash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks to everyone, especially Bhaskar for helping me out with this issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
SAP R/3 installation created 6 tablespaces by default. Here are name of their tablespaces :
PSAPTEMP
PSAPUNDO
PSAP[SID]
PSAP[SID]620
PSAP[SID]UDR
SYSTEM
I am using SAP R/3 Enterprises 4.7 ext 200 version. It may be different if you are using old or new ones
I have some more document to share with you
SYSTEM Includes the internal Oracle dictionary.
PSAPROLL Contains the rollback segments.
PSAPTEMP Temporary tablespace for internal processing.
BASIS tablespaces. These tablespaces contain the R/3 Basis environment data.
PSAPEL<rel>D/I <rel> = R/3 release
Contains loads for the development environment. Are releaseu2212dependent (for
example, PSAPEL45BD for release 4.5B).
PSAPES<rel>D/I Contains the sources for the development environment in this release.
PSAPLOADD/I Contains the ABAP report loads and screens.
PSAPSOURCED/I Contains the ABAP report sources and screens.
PSAPDDICD/I Includes the ABAP dictionary.
PSAPPROTD/I Includes control and log tables. APPLICATION tablespaces.
PSAPCLUD/I Contains the system cluster tables.
PSAPPOOLD/I Contains the system pool tables (i.e., ATAB).
PSAPSTABD/I Contains master data, transparent tables.
PSAPBTABD/I Contains transaction data, transparent tables.
PSAPDOCUD/I Contains documentation tables.
CUSTOMERS tablespaces.
Data Storage: Tablespaces and Data Files 514
PSAPUSER1D/I Includes the customer tables.
Regards
Bhaskar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
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.