Solved

How to increase the size for PSAPUNDO tablespace?

Posted on 2008-10-01
2
4,506 Views
Last Modified: 2013-12-19
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?

Thanks,

Felipe
0
Comment
Question by:Carlos_Felipe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 500 total points
ID: 22620540
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
 

Author Comment

by:Carlos_Felipe
ID: 22626932
Thanks for your reply.

Actually, it works, but I used SAPDBA to do it.

Thank you again,

Felipe
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question