troubleshooting Question

How do I Create a CRON JOB to take a DAILY FULL EXPORT at 10.30 p.m.of the 9.2 database on Sun 5.8 on Solaris?

Avatar of as93is
as93is asked on
Unix OSOracle DatabaseSystem Programming
8 Comments1 Solution1473 ViewsLast Modified:
Create a CRON JOB to take a DAILY FULL EXPORT at 10.30 p.m.of the 9.2 database on Sun 5.8 on Solaris.
I have to take FULL EXPORT of the ORACLE 9.2 database DAILY at 10.30 p.m.
I have to automate this process on Solaris as a cron job which should include the EXP command with parameters and make it work today.  This is URGENT.
How do I set the environment? cron env and my Korn Shell env
How do I include username and password? - oracle login information for the EXP command
I am beginner with cron jobs.  What should be the cron job command for DAILY EXPORT at 10.30 p.m.?
After the export is done, I want to move the dmp file to a backup server.  How do I do this?

Here is my EXP command:

FILE=/my/expdaily.dmp
LOG=/my/expdaily.log
FULL=y
GRANTS=y
INDEXES=y
ROWS=y
CONTRAINTS=y
STATISTICS=compute

I would be thankful if you could please help me with the above.  This is for an URGENT deadline which is today (04-12-2008)

Regards,
Inthira
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros