If you are talking about using compressed tablespace datafiles, such as
on MS-$$$$ compressed drives, it is usually frowned upon. This is
because ORACLE has no way to know how much room a tablespace actually
has on its disk. If you create a 100MB tablespace datafile, store 50MB
in it that is stored compressed to 20MB on the drive, when oracle trys
to write another 50MB to it, the additional space may not be there.
> Try using pipes if you're on Unix. On NT, you'll have to do it in two
> discrete steps.
> David C. Sisk
> Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at
> Like original music? Listen to song samples and buy a CD at
> >Hello everybody !
> >After figuring out that a Oracle compressed dump file can be
> >to less than 20 percent of its size by external compression software
> >got the idea of including external software into Oracle processes.
> >Is this possible in general ? And if yes, can I only run external
> >programs by calling them like in a shell or can I include them for
> >instance like a filter process in a byte stream produced by Oracle??
> >We are running 8.0.5 on NT.
> >Ciao and Thank You, Michael.
Joseph R.P. Maloney, CCP,CSP,CDP
some witty phrase goes here, I think.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.