Re: Tablespace Question

From: Lyubomir Petrov <lpetrov_at_sysmaster.com>
Date: Sat, 03 Jul 2004 00:53:30 -0700
Message-ID: <40E665FA.4050609@sysmaster.com>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sat Jul 03 2004 - 02:50:36 CDT