Re: EXP and Tablespaces

If this hasn't changed since 7.3 then the following is my understanding how it works:

If the tablespace that the table was exported from exists ( and the owner of the table still has a quota on it) that tablespace will be used by IMP -

If the tablespace does not exist, or the owner has had their quota removed from it, the DEFAULT tablespace for the IMP user will be used...

hth,

"stevie" <sluetge_at_siliconplanet.de> wrote:

>Is there any way I can tell the IMP procedure NOT to use the original (the
>ones that where in use at EXPORT-Time) tablespaces for tables when importing
>? What happens when a certain tablespace does not exist ?
>Thanks for any advice
>Stefan

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Mar 24 2000 - 15:54:11 CET