Re: export utility

hi Susanne,

the dumps contains sql-statetements like this: create table tab_nam1 (.....) Tablespace old_tablespace.

while the new owner has the privlileg 'unlimited tablespace' the table tab_nam1 is createted in the old tablespace.

what to do:

connect as system/***

SQL> REVOKE UNLIMITED TABLESPACE FROM new_owner; SQL> alter user new_owner quota unlimited on new_tablespace;

after that all tables of new_owner are created in tablespace new_tablespace

ciau Matthias

Clinique wrote:

> Hi everybody,
> I want to export tables from one tablespace owned by one user and after that
> import them into another tablespace owned by another user, all within one
> database. Sounds simple, I thought. Yet, after Oracle has successfully
> finished the import I find the imported tables in the new owners schema but
> still in their old tablespace. Why?
> Susanne
Received on Thu May 18 2000 - 00:00:00 CDT