Re: export utility

From: Christoph Wagner <christoph.wagner_at_gamed.com>
Date: 2000/05/17
Message-ID: <8fu2n9$5qr$1@readme.inode.at>#1/1

Export-Utility stores all the storage parameters of an object so the object is created with the sam params by the import-utility EXCEPT the object exist !!

why don't you create your tables by doing :

Create table user2.table
TABLESPACE tbsp_2
AS select * from user1.table;

Clinique <clinique_at_gmx.net> schrieb in im Newsbeitrag: 8fu4k5$8d4$1_at_nntp.hamburg.pop.de...
> 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 Wed May 17 2000 - 00:00:00 CDT