I need to increate the size for PSAPUNDO tablespace on Oracle on Windows.
I've never done it before and it's quite urgent.
How can I do it? Do I need to use BRTOOLS?
There are quite a few ways that you can accomplish this, here are 2:
Increase the size of existing files (you can get the names of the files from DBA_DATA_FILES). Put any size in that you want 2048m (2G) is just an example.
ALTER DATABASE DATAFILE 'C:\.....' RESIZE 2048M;
The other way is to add another file to the tablespace. Again the size is just an example.
ALTER TABLESPACE PSAPUNDO ADD DATAFILE 'C:\.....' SIZE 2048M;
All of these commands can be run from SQL*Plus.
Another way to add space is to turn on autoextend for the files. Not my personal preference, but it is another option.
0
Carlos_FelipeAuthor Commented:
Thanks for your reply.
Actually, it works, but I used SAPDBA to do it.
Thank you again,
Felipe
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Increase the size of existing files (you can get the names of the files from DBA_DATA_FILES). Put any size in that you want 2048m (2G) is just an example.
ALTER DATABASE DATAFILE 'C:\.....' RESIZE 2048M;
The other way is to add another file to the tablespace. Again the size is just an example.
ALTER TABLESPACE PSAPUNDO ADD DATAFILE 'C:\.....' SIZE 2048M;
All of these commands can be run from SQL*Plus.
Another way to add space is to turn on autoextend for the files. Not my personal preference, but it is another option.