Move tablespace

[Former Member]

Hello Guys,

My database drive(F:)size is full and also the tablespaces are also near to 90%. So I cann't add datafile to tablespace bcoz the drive is having only 2 gb free space .

G: Drive is having 100 gb Free Space.

Now I want to move the tablespace or datafile from F: drive to G: and add datafile to new Drive(G:).

Can anybody tell me how to move tablespace to datafile??????

Regards,

[Former Member]

Hi,

if u r using SAPDBA -

---

> table space administration u can specify new path.

Kishor

[Former Member]

Or you can use BRTOOLS under Space Management.

[andreas_herzog]

in order to move the tablespace you need to (plz use <sid>adm...and sqlplus)

1. set the tablespace offline (alter tablespace <ts_name> offline)

2. copy the data file(s) to the new location, eg. somewhere on disk G: (be sure to follow the naming conventions...\oracle\<SID>\<ts_name_without_psap>\...)

3. rename the tablespace datafile by typing "alter tablespace <ts_name>

rename datafile \oracle\<SID>\<old> to \oracle\<SID>\<new>"

4. set the tablespace online: alter tablespace <ts_name> online;

5. delete the old ts-file from the fileysystem using windows explorer or command prompt

GreetZ, AH

[Former Member]

Hi,

If ur using sapdba u can create new datafile in g: drive itself. all u need to do is manually create the g:\oracle\sid\sapdatax\ directories..

Regards

Umesh K