Re: ORA error 1115 during export

In article <390DB5C4.BA950EA6_at_yahoo.com>,   Nikita <Nikita_at_yahoo.com> wrote:
> yong, thanks.
>
> I would love to run dbv on the hotbackup of the file, but for some
 reason
> this utility doesn't allow you to on files that are 2GB in size (and
 only
> 2GB).
> Any suggestions?
> (I may just need to call support on this one)

I don't know if it's dbv or the underlying OS that limits dbv to 2GB. Assuming the latter, have your system admin take care of the OS. Not sure whether you can change an existing file system to a largefiles type. Find out whether yours is already that type by the command "mount" and look for something like: /disk2 on /dev/dsk/c0t1d0s2 setuid/read/write/largefiles on Tue Apr 18 15:01:23 2000

A wild guess. No expert has mentioned this before. I wonder if you can pipe your large file (preferably compressed) to dbv. Something like: compress myfile.dbf
mkfifo mypipe
dbv mypipe &
cat myfile.dbf.Z | uncompress | dd of=mypipe

In any case, Oracle support should be able to help.

--
Yong Huang

(yong321_at_yahoo.com)
(http://www.stormloader.com/yonghuang/)


Sent via Deja.com http://www.deja.com/
Before you buy.