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

Home -> Community -> Usenet -> c.d.o.server -> I need Oracle help. Lotsa questions here. Oracle autostart options? Oracle SQL Cron? Online export?

From: <paul_wass_at_my-dejanews.com>
Date: Sun, 20 Sep 1998 11:58:57 GMT
Message-ID: <6u2qm1$rrb$1@nnrp1.dejanews.com>

We're running Oracle 7.3 on a Novell Netware box.

I have a multiple questions here.

Is there any way to automatically have Oracle run a set of 'Stored procedures' when the database first starts up?
Similar question. Is there any way to automatically have Oracle run a set of 'SQL scripts' when the database first starts up?
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?
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 Received on Sun Sep 20 1998 - 06:58:57 CDT