move extended table space into other drive

[Former Member]

Hi SAP BASIS GURUS,

Is it possible to move extended table space to another drive? My issue is that the storage drive(contains tablespace) has only 15mb of free space because of autogrow. I have a new drive to extend the tablespace. I know how to extend my worry is that how to free up space in my 15MB freespace drive. Im planning to move some tablespace but i dont know whether it is possible.

Details:

OS: windows 2003

DB: oracle

SAP: 4.6D

Please help.

Thanks and regards,

Joel

[l_nemzov]

there is 2 ways

1 move datafile on new drive

2 switch off autoextend on datafile in this tablespace and add datafile on new drive

[Former Member]

Hi Joel,

What you have asked in your question is possible. Tablespace is a logical entity and contains Datafiles which may be present in any of the available drives.

What is your oracle DB version. You can perform this operation using BRTOOLS but before doing that, please ensure to upgrade your BRTOOLS to the latest version.

Good Luck.

Regards,

Hari Kishan

[Former Member]

Hi Joel,

Let me know your oracle version.

Tablespace export/Import can be done to free up the space from existing drive.

Regards,

Rajesh

[Former Member]

Hi Gagan,

I will try to implement the link you provided will inform you once successful.

Hi Rajesh,

Release: Oracle version 9.

DB client Lib: OCI_920_SHARE__OCI_7_AP

Thanks and regards,

Joel

[Former Member]

Hi Joel,

Its veru much possible to move datafile using brtools, So you can move existing file from one drive to another using brtools, you may need to consider upgrade of brtools before doing this , as its always better to use latest brtools

http://help.sap.com/saphelp_nw04/helpdata/en/1e/5f863f06593a17e10000000a114084/content.htm

Tablespace contains datafiles only ,

Regards,

[Former Member]

Hi Gagan,

The link you have provided is very useful. Problem solved.

Thanks and regards,

Joel

[Former Member]

Hi Gagan,

I think there is a problem in my forum dashboard. I could not mark this as an answered nor can not give you points. But Im really grateful for the support.

Thanks and best regards,

Joel

[Former Member]

Hi,

can not give you points

That does not matter , make sure you set thread as answered may be later

Regards,