Create Tablespace on different disk

[Former Member]

Hi!

I am about to upgrade SAP ERP 6.0 to EHP4.

As one of failed cheks was the insufficient free space in the database.

The recommendation given by Tool (EHP Installer) was:

> Create TABLESPACE PSAPSR3701 with 53181 MB

I also found in the ORATBSXT the appropriate SQL commandos

brspace -function tscreate -tablespace PSAPSR3701 -owner SAPSR3 -data both -size 20000 -autoextend no

brspace -function tsextend -tablespace PSAPSR3701 -size 20000 -autoextend no

brspace -function tsextend -tablespace PSAPSR3701 -size 13181 -autoextend no

My problem is that I do not have 53181 MB free space on my Oracle disk.

Therefore I mounted other disk with 70 GB free space and created there the appropriate path

F:\oracle\<sid>\sapdata7\sr3701_1

Question:

What is the SQL commando to create a new tablespace with 53181 MB on new partittion F:\oracle\<sid>\sapdata7\sr3701_1?

Someting like:

>brspace -function tscreate -tablespace PSAPSR3701 -owner SAPSR3 -data both -size 53181 datafile 'F:\oracle\<sid>\sapdata7\sr3701_1\sr3701.data1' -autoextend no

Thank you very much!

regards

[Former Member]

If in doubt, try -h (for 'help') option:

brspace -h tscreate

[Former Member]

Hi!

Thank you!

Could you give me more concrete information for my query?

Thank you!

[Former Member]

It shouldn't be too difficult to find your solution from the two answers you got so far.

I don't know the answer by heart, and I am too lazy now, sorry.

[Former Member]

Hai,

Use BRTools to create the New Tablespace.

http://help.sap.com/saphelp_nwpi71/helpdata/en/46/ba3930d28a1513e10000000a114a6b/frameset.htm

Regards,

Yoganand.V