Dear all ,
SAP 4.7 ,Win2003 , Oracle 9i
I have checked the DB Upgrade guide from Ora 188.8.131.52 to 10.2
I have execute the below command for checking the current SYSTEM tablespace and i got error.
Checking the SYSTEM and SYSAUX Tablespace for
Table space error:
D:\Ora_RDBMS\NT\I386>brspace -f dbshow -c tsinfo -s SYSTEM
'brspace' is not recognized as an internal or external command,
operable program or batch file.
the Upgrade guide also mentioned the below step to setup AUTOEXTEND ,
If the free space is less than 750 MB, use your preferred database administration tool to increase the size by using one of the following options:■
Setting the AUTOEXTEND option for the existing datafile to ON.
Kindly suggest how to check free space for SYSTEM Tablespace (SAP 4.7 version)
The command you are using is working fine for me.
> brspace -f dbshow -c tsinfo -s SYSTEM
1. Login to your database server ( where your oracle is running) with user id , <SID>ADM
2. Open command prompt and run the same command.
Otherwise , you can see the same information from SAP level via Tcode DB02.