Re: export/import

"Tim Arnold" <timkarnold_at_comcast.net> wrote in message news:k5Kdnf0DuouUI5DeRVn-3w_at_comcast.com...
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:igrqg1pkn4g6ng5ns2cpi5roddlvteueup_at_4ax.com...
>> On Thu, 25 Aug 2005 05:03:47 GMT, bards <bards1888_at_yahoo.com.au.au>
>> wrote:
>>
>> >Use level schema exports
>> >imply me having to do all the other system stuff up front unless I'm
>> >mistaken, that is create users, create roles, grant privs etc. Am I
>> >wrong ? It seems like a lot of work with the potential for human error
>> >(my typos etc).
>>
>> No, that is right. You want to avoid schema level imports.
>> Please note also that when you have direct grants made by SYS to end
>> users, those won't be exported.
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
>
> Do 2 exports. One full export w/no data. And one user level schema.
> The first one will get user, roles, grants, etc.
>
>

Is it possible to do a full export of Oracle 8i and import that into 10g wihtout messing up the 10g data dictionary ? Is the syntax for creating users and roles of 8i fully compatible with 10g ? Received on Thu Aug 25 2005 - 07:57:05 CDT