Can one rename a tablespace?

4 like 0 dislike

Hello

Can one rename a tablespace?

Please give me your feedback......

asked 1 year ago by rad_joshep (19,390 points)

1 Answer

2 like 0 dislike

Best answer

No, this is listed as Enhancement Request 148742. Workaround:
Export all of the objects from the tablespace
Drop the tablespace including contents
Recreate the tablespace
Import the objects

answered 1 year ago by daneim (127,080 points)

Related questions

5 like 0 dislike

1 answer

What is difference between Rename and Alias?

asked 1 year ago by daneim (127,080 points)

5 like 0 dislike

1 answer

Can a primary key contain more than one columns?

asked 1 year ago by marck_don (191,010 points)

5 like 0 dislike

1 answer

How can you switch from one to another ?

asked 1 year ago by rad_joshep (19,390 points)

4 like 0 dislike

1 answer

How can one dump internal database structures for DBA?

asked 1 year ago by marck_don (191,010 points)

4 like 0 dislike

1 answer

How can one improve Import/ Export performance for DBA?

asked 1 year ago by marck_don (191,010 points)