Re: Export/import question

From: David Sisk <davesisk_at_ipass.net>
Date: Mon, 16 Aug 1999 22:25:34 -0400
Message-ID: <Oz3u3.977$tp2.798@news.ipass.net>

Hi:

If you do a full import, tablespaces, users, all settings EXCEPT grants made on objects owned by SYS will be imported. If the tablespaces don't already exist, it will create them.

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

wozi wrote in message
<73E17C05EBF6FB64.055CA2F193E5FE92.B4A2513F6D4E0F2B_at_lp.airnews.net>...
> I like to do a full export from oracle to oracle8.
>Will the tablespaces, usernames, user' default and temp tablespaces
>definitions automatically be placed correctly as it was in 7. Do I have to
>first create the tablespace and users in 8 before importing fom oracle7?
>
>thanks,
>
>
>
>
Received on Mon Aug 16 1999 - 21:25:34 CDT