PSAPUNDO recreated

[Former Member]

Hi DBA Team,

As per below link i have dropped and recreated PSAPUNDO tablespace,

I used below commands with " reuse autoextend off" and "reuse autoextend on"

-

---

SQL> create undo tablespace PSAPUNDO2 datafile '/oracle/TBW/sapdata4/undo2_1/undo2.data1' size 2049M reuse autoextend off ;

SQL> create undo tablespace PSAPUNDO datafile '/oracle/TBW/sapdata2/undo_1/undo.data1' size 40960M reuse autoextend on ;

-

---

I have recreated PSAPUNDO tablespace successfully.

But when i check in DB02 in SAP level output is showing as below,.

Size(MB) | Autoextension |_Max Size(MB)_

40960 | Yes | 63488

Why Max size 63488 MB created, Is there any way i can bring that value to 40960 ?

I want to make size (MB) and max size(MB) as equal.

Please help.

Regards

Kumar

[volker_borowski2]

> I have recreated PSAPUNDO tablespace successfully.

> I want to make size (MB) and max size(MB) as equal.

uuups, sorry!

That sounded to me as if you like to change the situation, so I suggested ALTER TABLESPACE.

Anyway, the autoextend-clause works well for tablespace creation as well:

create undo tablespace PSAPUNDO datafile '/oracle/TBW/sapdata2/undo_1/undo.data1' 
size 40960M reuse autoextend on maxsize 40960M;

If you use brtools/brspace, you can fill in all values menu driven.

Volker

[Former Member]

Thanks Volker,

Its working now size and max size is equal now

But with below create statement my increment value is showing '1' i want increment value as '25600'.

create undo tablespace PSAPUNDO datafile '/oracle/PS2/sapdata10/undo_1/undo.data1'

size 40960M reuse autoextend on maxsize 40960M;

First i created a PSAPUNDO table space with above create statement i got increment value as '1' then second data file added from brtools i got increment value '25600'

what can i include in above create statement to get increment value as '25600'

Regards

Kumar

[volker_borowski2]

Hi,

that would be

autoextend on next 25600 maxsize 40960M;

But I think it better should be next 10M

BTW, try a google with "create tablespace syntax" to get the full information for this statement.

Volker

[Former Member]

Thanks for all your help Volker,

Regards

Kumar

[volker_borowski2]

> SQL> create undo tablespace PSAPUNDO datafile '/oracle/TBW/sapdata2/undo_1/undo.data1' size 40960M reuse autoextend on ;

alter database datafile '/oracle/TBW/sapdata2/undo_1/undo.data1' autoextend on maxsize 40960M ;

Best regards

Volker

[Former Member]

Thanks for your reply Volker,

I am aware about alter command, we can change the data file size with above command.

But i need a command with 'create'.

I need to do in production system.

For below command make a necessary change please, I need size (MB) and Max size (MB) equal while creating a PSAPUNDO tablespace

I dont want to change dataafile size after creating a tablespace.

create undo tablespace PSAPUNDO datafile '/oracle/PS3/sapdata6/undo_3/undo.data3' size 40960M reuse autoextend on ;

Your reply will help me..

Regards

Kumar

[JPReyes]

I dont want to change dataafile size after creating a tablespace.


....size 40960M reuse autoextend on ;

Then switch autoextend off

Regards

Juan