Re: [Q] Can I rename TABLESPACE ?

Huy Vu wrote:
> We have 2 databases A & B. The only different between them is:
>
> A was created tablespace with the name USER and B was created tablespace
> name USERDATA.
>
> Can I rename USER tablespace in A to USERDATA before import the dumpfile
> from B?

Oracle does not have such function to rename a tablename's name. For importing data purpose, you can create users in database A with only quota on USER
can help you import data from tablespace USERDATA.

Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049