Re: export/import

From: Tim Arnold <timkarnold_at_comcast.net>
Date: Thu, 25 Aug 2005 08:52:54 -0400
Message-ID: <k5Kdnf0DuouUI5DeRVn-3w@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. Received on Thu Aug 25 2005 - 07:52:54 CDT