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

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

From: Terry Porter <ifly_at_iname.com>
Date: Sat, 26 Sep 1998 17:11:24 -0500
Message-ID: <6ujp4t$8vs$1@holly.prod.itd.earthlink.net>

Of note: the export parameter CONSISTENT=Y will ensure data integrity in case your database is seeing activity during the export.

If you want to prevent access during an export, (as long as users don't have the DBA role granted to them!) you can also perform the SQL stmt ALTER SYSTEM ENABLE RESTRICTED SESSION, which will prevent any new logins unless privs are granted to a user regarding this (or the user has the DBA role granted to them). When export is complete, ALTER SYSTEM DISABLE RESTRICTED SESSION to allow normal logins again.

>>4) Can an export be done while the database is up and running with no
users
>>logged in?
>>
>Yes and no.
>
>Technically -- not really since if you are doing an export YOU are logged
in.
>The database MUST be up and at least one person (the exporting user) will
be
>logged in. You can export with users logged in as well...
Received on Sat Sep 26 1998 - 17:11:24 CDT