How to rename Tablespace

[Former Member]

Can anybody tell me the procedure for renaming a tablespace in Oracle 10g.

Thanks in advance

[former_member204746]

easy solution:

1. stop SAP (recommended)

2. run:

brspace -c force -u / -f tsalter -a rename -t PSAP_OLD -n PSAP_NEW

[rajeev_das]

If you aren't comfortable with SQL statements, you can use brtools for that.

Brtools and select the following options -

2 - Space management

4 - Alter tablespace

3 ~ Alter tablespace action (action) . []

rename

4 ~ Tablespace names (tablespace) .... []

[Enter OLD tablespace name here]

c [enter c twice]

c

5 ? New tablespace name (name) ......... []

[Enter NEW tablespace name here]

c

y

c

c

s

PS: Awards points if useful.

Cheers,

Rajeev

[Former Member]

Hi,

you can rename tablespace using alter command

ALTER TABLESPACE name RENAME TO newname

However, you must follow the rules when renaming a tablespace:

• You must set compatibility level to at least 10.0.1.

• You cannot rename the SYSTEM or SYSAUX tablespaces.

• You cannot rename an offline tablespace.

• You cannot rename a tablespace that contains offline datafiles.

• Renaming a tablespace does not changes its tablespace identifier.

• Renaming a tablespace does not change the name of its datafiles.

regards,

kaushal