Re: export/import

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 25 Aug 2005 09:08:02 +0200
Message-ID: <igrqg1pkn4g6ng5ns2cpi5roddlvteueup@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

Received on Thu Aug 25 2005 - 02:08:02 CDT