Re: URGENT

In article <6aoqna$bg7_at_news.microsoft.com>, Benson Zhang <v-acbz_at_microsoft.com> wrote:
>How can I set fast readable snapshot when tables in my master tables does
>not have primary key constraints.
>
>
>Another question is:
>
>I have about 14gb database. If snapshot can not be set, I want to do
>complete export at the beginning and incremental every day. How fast it
>will be for exp then imp???
>
>My environment
>NT4.0, Oracle 8
>Hardware (Compaq high end server with RAID)
>
>
>Your help is really appreciate
>
>
>

I have a similar sized database on a sparc with RAID 0+1. Compressing through pipes to another machines RAID-5 disk, complete exp takes about 11 hours. YMMV.

You might check if your volume manager can do a filesystem mirror for you. Veritas on a Sun can do a snapshot filesystem in seconds. Whether you want to do this depends on the purpose of your snapshot.

>Benson
>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!