Re: export utility

On Wed, 17 May 2000 14:51:29 +0200, "Clinique" <clinique_at_gmx.net> 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
>
>

Hi,

If you want to move objects from one tablespace to another, you have to revoke quota on the original tablespace from the user, then you give quota on the new tablespace to the user into which you import. The target tablespace has to be the default tablespace of the user. This way, when import will not be able to create an object in the original tablespace (because you revoked quota on it) it will create the object in the default tablespace.

Be careful with indexes, they will end up in the default tablespace as well unless you did not revoke quota on their original tablespace from the user.

In this case, you should import with INDEXFILE=some_file_name, then change the default target tablespace and run the created index creation script from sql*plus (you might have to edit it to change tablespace name to new name)

Hope this helps Received on Wed May 17 2000 - 00:00:00 CDT