Re: Tablespace Question
- From: Lyubomir Petrov <lpetrov@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 03 Jul 2004 00:53:30 -0700
Mike,
Oracle 10g:
alter tablespace X rename to Y;
Before Oracle 10g:
- create tablespace Y
- move objects from tablespace X to tablespace Y
- drop tablespace X
Regards,
Lyubomir Petrov
Vergara, Michael (TEM) wrote:
>Hi All...heckuva thing to be working on a long holiday
>weekend...but what the heck. Got a question for=20
>everybody. How can I rename a tablespace? Is it
>even possible? There's nothing in the Oracle Docs
>about it, and I haven't yet checked Ask Tom, but I
>thought I'd seek the collective wisdom of the group.
>
>I need to change a tablespace's name and keep the contents
>intact, and under the same ownership. Any ideas?
>
>Help!
>
>...and Thanks!
>
>Mike
>
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
