| regarding backup [message #22332] |
Fri, 04 October 2002 19:44  |
psshastri
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
Hi,
I would like to export the tables daily in the morning automatically using dbms_job.How should I do this?
Explain me in detail.
thanx in advance
shastri
|
|
|
|
| Re: regarding backup [message #22371 is a reply to message #22332] |
Tue, 08 October 2002 01:38  |
Xiang Fang
Messages: 4
Registered: October 2002
|
Junior Member |
|
|
|
I think "exp" is a external oracle utility at OS level. So it is very difficult to call "exp" from pl/sql code, but you still can try extproc(external procedure call) to do this. Oracle can call extproce(.DLL in windows or .so in UNIX). But there is a better way to do what you want to do, that is the schedualed job function at OS level, such as "crontab" in UNIX.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
