Skip to Content
0
Former Member
Mar 24, 2009 at 10:43 AM

Create Tablespace on different disk

208 Views

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