http://VietEnglish.com

http://Edgar411.com

http://ForumGrouper.com

http://hpricot.com

exportInfo.html
10-18-2001 Bikle
-----------------

This page displays some info about suitable places to put export files on bikle01.

If we check the crontab we find the following interesting entry:

59 23 * * * (. /home/oracle/.biklepr; /home/oracle/bik/bin/Fullexp.sh) > /mnt/filer01/db/biklepr/export/Fullexp.log 2>&1

Careful reading of 
/home/oracle/bik/bin/Fullexp.sh
reveals that we are placing export files here:

/mnt/filer01/db/biklepr/exp

Output from df reveals the amount of free space in the above directory:

bikle01-oracle-% date
Thu Oct 18 18:46:31 PDT 2001
bikle01-oracle-% df -k /mnt/filer01/db/biklepr/exp
Filesystem            kbytes    used   avail capacity  Mounted on
filer01:/            62593232 55258496 7334736    89%    /mnt/filer01
bikle01-oracle-%

Currently we have about 7gb of data free in /mnt/filer01 which should be
plenty of space to hold an export of the EVENT table.

Another cron entry which catches our eye is listed below:

# 09-06-2001 Bikle  /home/oracle/bin/purgeOldExp.sh added to purge old exp files
57 23 * * * /home/oracle/bin/purgeOldExp.sh > /mnt/filer01/db/biklepr/export/purgeOldExp.log 2>&1

Careful reading of 
/home/oracle/bin/purgeOldExp.sh
reveals the following UNIX "find" command:

/bin/find . -name 'biklepr_full.2*dmp.Z' -mtime +3 -print|xargs /bin/rm

We need to make sure that the export file name of our EVENT table does not match
the pattern: 'biklepr_full.2*dmp.Z'