Re: I need Oracle help. Lotsa questions here. Oracle autostart options? Oracle SQL Cron? Online export?

Have a look at the DBMS_JOB package included with the RDBMS. A better answer for job scheduling would be to use Jobs and Events in Oracle enterprise manager. The UI is graphic in nature and allows you to schedule jobs by time or a job can be triggered by an event.

What sort of jobs are you trying to run? Maybe there is a better method.

With regards to Exports, they can only be done when the database is up. It does not matter if someone is connected to the database. In fact exp itself is a database connection. If you are backing up the database (making copies of the Data, redo and control files, then the database must be either shutdown or the tablespace put in backup mode (alter tablespace tsname begin backup). This method is refered to as a hot backup, and requires that the database be in backupmode, and the O/S or backup software supports open files.

In article <6u2qo7$rsv$1_at_nnrp1.dejanews.com>,   paul_wass_at_my-dejanews.com wrote:
> We're running Oracle 7.3 on a Novell Netware box.
>
> I have a multiple questions here.
>
> 1) Is there any way to automatically have Oracle run a set of 'Stored
> procedures' when the database first starts up?
>
> 2) Similar question. Is there any way to automatically have Oracle run a set
> of 'SQL scripts' when the database first starts up?
>
> 3) Does Oracle have any type of Cron built into it for running Stored procs
> or Sql scripts? If not, is it possible to write a Store procedure that acts
> like a CRON and runs itself or other procs at certain times?
>
> 4) Can an export be done while the database is up and running with no users
> logged in?
>
> That's all my questions for now. Thanks to anyone who can help!!!
>
> Paul
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 22 1998 - 20:44:57 CEST