Re: FULL vs USER (EXPORT UTILITY QUESTION)

On Mon, 20 Dec 2004 16:47:06 -0500, Rob Williamson <robw_at_physics.umd.edu> wrote:

>Assuming that my primary backup strategy is
>nightly file backup ( oracle 9i on small Database < 500M )
>I am wondering wheter a nightly User( owner ) Export might be more than
>sufficient for a secondary backup of table info assuming we have all
>the updated scripts to recreate the database, tablespaces, users,
>tables, synonyms, constraints,roles and grants? If all I really care
>about is the data. I am just wondering whether doing a FULL Export is
>overkill vs User Export. Or is the basic rule of thumb of having more
>information better? Is there more complexity to using the Import
>utility from a FULL vs. Table or User?
>
>Thanks
>Rob

the basic rule of thumb is that a full export is always complete. Eg: if your user did receive grants from other users, and you have an user export only, you will be missing out those grants. Importing a full database export, rows=n, grants=y is always completely non-invavise. If you have only one user-schema, and the size of that schema exceeds the administrative overhead, I wouldn't bother and always export full. It almost always allows you to do away with a whole lot of admininstrative hassles, and in terms of complexity of importing there is no real difference.

--
Sybrand Bakker, Senior Oracle DBA