Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Fuzzy datafile?

Re: Fuzzy datafile?

From: Ivan Bajon <bajon_at_nospam@worldonline.dk>
Date: Mon, 23 Apr 2001 15:02:02 +0200
Message-ID: <9c1949$qph$1@news.inet.tele.dk>

I forgot to mention that the "easiest" way to avoid this is to shut down the source database before you begin to copy.

Regards,
Ivan Bajon

"Ivan Bajon" <bajon_at_nospam@worldonline.dk> wrote in message news:9c1809$nin$1_at_news.inet.tele.dk...
> It happens if you copy a datafile !without! putting the tablespace in
 begin
> backup mode first and use this datafile elsewhere (e.g. you cloned your
> database). The data file can contain "split blocks" so you need to copy it
> again - this time using begin backup on the tablespace.
>
> Regards,
> Ivan Bajon
>
> "Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote in message
> news:mlED6.47$iw5.46899_at_news0.telusplanet.net...
> > In the v$datafile_header view there is a column called Fuzzy. Others
 like
> > v$datafile_copy also contain 'fuzzy' columns. What does Fuzzy mean?
> >
> > --
> > Terry Dykstra
> > Canadian Forest Oil Ltd.
> >
> >
>
>
Received on Mon Apr 23 2001 - 08:02:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US