Encrypting file on Unix

crypt: Encodes (encrypts) or decodes a file
usage: crypt [options][file]
options: password
example: crypt key <> encrypted.file
example: crypt key < encrypted.file | lpr

Resource:

http://www.u.arizona.edu/udocs/unix-cmds.html#crypt

SQL script to obtain tablespace usage for objects in Oracle

Below is a script that will report the amount of space each object (table, index, etc) is taking up in its associated tablespace:


select substr(SEGMENT_NAME,1,30) segment_name, SEGMENT_TYPE, substr(tablespace_name,1,30) tablespace_name, bytes/1024/1024 mbytes
from user_segments
order by mbytes desc