How to move a device from a database to another?

[Former Member]

Hi,

I accidentally alter the device to a wrong database after I resize it. How can I move this device to correct database?

Thanks,

Joven

[Johan_sapbasis]

Hi ,

I have just added a blog which might suite your error.

Regards,

Johan

[Former Member]

Hi Nicolaas,

Can you share the link here?

Thanks,

Joven

[Johan_sapbasis]

Hi Joven,

Johan

[Former Member]

Did you try to use brtools to resolve your issue ?

[crisnormand]

Hello,

Note that this site is about SAP ASE, not Oracle

Regards

Cris

[Former Member]

Oh, sorry, I missed that fact

[Former Member]

Hi Igor,

No. Actually I'm resizing the device on the database . I execute this command:

disk resize name='saptools_data_001', size='1024M'

go

alter database TST ON saptools_data_001 ='1024M'

go

In the alter command, the database should be saptools not TST. That is why the device saptools_data_001 is now on both TST and saptools database.

The question now is how do i remove the device saptools_data_001 in TST database so that it will only be in saptools database.

Thanks,

joven

[crisnormand]

Hello,

You should be able to shrink the TST database using the alter database command with off parameter and specifying the device name from which you want to release space.

Regarding restrictions specific to a Business Suite context when shrinking a database, check SAP Note 2073343 - SYB: Release information for SAP ASE 15.7 SP13x
> Shrinking databases

HTH

Cris

[Former Member]

Hi Cris,

I'm trying the link you have posted but it is not available. You've said that I can shrink the TST database, how can I do it?

Thanks,

Joven

[crisnormand]

Hello Joven,

You can access the ASE documentation here: http://help.sap.com/adaptive-server-enterprise.

The syntax is

alter database database_name
. . .
     off database_device {=size  | [from page_number] [to page_number]}
     [, database_device…]
     [with timeout='time']

[ ] means optional

Note the shrink database operation must be performed while the SAP system is offline, and after, you have to do a full database dump (TST and master).

HTH

Cris

[Former Member]

Hi Joven. What do you mean when you saying alter device to database ? You are adding a new tablespace file on a new volume ?