Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: feedback welcome about exports
It probably depends on how many user's have schemas in the database....
( duh ! , I am a master of the obvious!)
If using the user method, be sure not to forget sys and system ...
hope it helps...
GreyWolf_69 <GreyWolf_69_at_alloymail.com> wrote:
>I was wondering what other dbas thought about this:
>
>Is it better to do nightly exports, one for each user's data?
>
>or
>
>do a full export every night?
>
>put aside for a minute all the backup options. Just consider the above,
>is it easier to do each user's data, thereby making it quicker to
>restore a single user's data? or to select a user's data from a full db
>dump?
>
>I'm new to all this and just thought I'd throw this out there.
>
>
-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Oct 06 1999 - 11:56:48 CDT