Your tablespace PSAPBTABD is 92% used. How to increase the free space?
SAPDBA V3.1I - SAP Database Administration
____________________________________________________________________________
ORACLE version : 7.3.4.3.0
ORACLE_SID : ALD
ORACLE_HOME : /oracle/ALD
DATABASE : open
SAPR3 : 31H, 23 times connected
a - Startup/Shutdown instance h - Backup database
b - Instance information i - Backup archive logs
c - Tablespace administration j - Check (and repair) database
d - Reorganization k - Restore/Recovery
e - Export/import l - Show/Cleanup
f - Archive mode m - User and Security
g - Additional functions n - Help
q - Quit
Please select ==> c
____________________________________________________________________________
Tablespace administration
____________________________________________________________________________
Current value
a - Tablespace:
b - Log checks: no
c - Free space and fragmentation of all tablespaces
d - Check free space of objects in all tablespaces
e - Check free space of objects in tablespace
f - Alter tablespace Add Datafile
g - Create/drop tablespace
h - Display all tablespaces and datafiles
i - Display raw device drivers in /dev
q - Return
Please select ==> a
Enter tablespace name [%] ==> psapbtabd
____________________________________________________________________________
Tablespace administration
____________________________________________________________________________
Current value
a - Tablespace: PSAPBTABD
b - Log checks: no
c - Free space and fragmentation of all tablespaces
d - Check free space of objects in all tablespaces
e - Check free space of objects in tablespace PSAPBTABD
f - Alter tablespace PSAPBTABD Add Datafile
g - Drop tablespace PSAPBTABD
h - Display all tablespaces and datafiles
i - Display raw device drivers in /dev
q - Return
Please select ==> f
____________________________________________________________________________
Alter tablespace PSAPBTABD add datafile
____________________________________________________________________________
Current value
a - File system or raw device: file system
b - File size: 2088960 K (larger than free space)
c - Select path: /oracle/ALD/sapdata5
d - Alter suggested path: /oracle/ALD/sapdata5
free space: 3608 K
e - Display current files: 10 files, total (in DB): 77
s - Start (Add datafile)
q - Return
Please select ==> s
Thursday, July 31, 2008
How to Increase the Tablespace free space?
Labels:
Basis Tables
Subscribe to:
Post Comments (Atom)
Archives
-
▼
2008
(137)
-
▼
July
(56)
- Useful SAP System Administration Transactions
- Changing the Title of SAP Transaction
- Search for SAP Basis Transaciton codes
- How to list all transactions executable for a role.
- List of Tcodes executable for a User in SAP
- How to view recently accessed transactions by user...
- How to find sap transaction codes IN SAP
- Sap Basis Transaction Codes 343
- Changing the Title of SAP Transaction
- Basis Tables Reorganization of Single Object
- How to Increase the Tablespace free space?
- How to activate the IMG Change Log?
- Basis - Edit, create, delete or adjust your databa...
- Finding any of the SAP tables that have been changed
- Transport Tables between Clients
- Copying table entries from client 000
- SAP Transaction Table
- SAP Tablespace sizes in large databases
- SAP SQL Tuning Aid with Oracle RDBMS Statistics
- How to exclude a table in client copy in SAP
- Bandwidth requirement of ISP to connect to SAP ser...
- See from which network IP address and host name a ...
- No System name and transaction code in SM04
- How to execute and External OS command in SAP
- Basis - Message Class - System Message
- SAP Notes Assistant
- Suspend/UnSuspend Released ABAP Jobs
- What Is The Job Name EU_REORG Meant?
- SAP Courses & Certifications for SAP Basis Admins
- Interview Questions for SAP Basis
- SAP Administration Questions Answers
- SAP Basis FAQ
- Basis Administration Questions Answers
- Administration SAP Administrator Daily Activities
- Tcodes used for Daily System Monitoring
- Monitor and Administrate 4 SAP Systems
- Brief Description About SAP Basis Implementation
- How to Check Missing Authorisation for User
- SAP Profile Generator tables
- Frequently Asked Questions on Authorization
- Query About Tcode PFCG
- How To Compare The Roles
- Creating New User With Authorizations
- How To Provide All Rights To The User
- Archiving and Reorganization are totally different...
- Archiving the Material Master
- Deletion of Vendor Consignment Records
- Reasons For Archiving Financial Accounting Data
- Archiving and Reorganization are totally different...
- Archiving the Material Master
- Deletion of Vendor Consignment Records
- Reasons For Archiving Financial Accounting Data
- SAP Administrator Daily Activities
- Tcodes used for Daily System Monitoring
- Monitor and Administrate 4 SAP Systems
- Brief Description About SAP Basis Implementation
-
▼
July
(56)
No comments:
Post a Comment