Re: space alert report

Two things spring to mind:

1)
In SQL*plus try SET TAB OFF. If you have SET TAB ON (it's the default), SQL*Plus will generate whitespace as mix of space and tab characters, which will make the output dependent on how the viewer defines tab stops.

2)
There's a mail MIME header to indicate that a mail is plain text (or it might be the code page, can't remember off hand but will try to find it), which will tell most email clients to use a fixed width font rather than proportional.

I guess one of those two things might be what is troubling you.

Regards

Kim Berg Hansen

http://www.kibeha.dk
kibeha_at_kibeha.dk
_at_kibeha <http://twitter.com/kibeha>

On Wed, Jun 1, 2016 at 3:04 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:

> Wrote a quick little space report to email myself. Looks like this on the
> unix box:
>
> TABLESPACE_NAME CurMb MaxMb TotalUsed
> PotentialFree UPercent
> ------------------------- ---------- ----------
> ------------ ----------------- ----------
> IDX 52767.9844 52767.9844
> 48800.9844 3967 92
> TEMP 3000 3000
> 2990 10 100
>
>
> Comes out like this in the email body:
>
>
> TABLESPACE_NAME CurMb MaxMb TotalUsed PotentialFree UPercent
> --------------- ---------- ---------- ---------- ------------- ----------
> IDX 52767.9844 52767.9844 48800.9844 3967 92
> TEMP 3000 3000 2990 10 100
>
> How can I format it better?
>
> Brian
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l