Re: EXPORT online?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 14 Jul 2001 10:09:40 +0200
Message-ID: <tkvvea2sj8m8b5@beta-news.demon.nl>

"JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0107132350.3d8dbe66_at_posting.google.com...
> Can I do Export when database online and users connected on it?
> Thanks for any thought,
>
> JK

Export is issuing a series of ordinary selects. The usual rules as to consistency and concurrency apply. If you have large rollback segments you can use the consistent=y parameter (documented in the Oracle Server Utilities Manual, please try to read it) or you can make the database inaccesible by either alter system set restricted_session = true (which will disallow any non-dba's access)
or simply stopping the listener.
If you want a complete overview please try to read the Oracle Server Utilities Manual, instead of posting questions on export every few hours.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sat Jul 14 2001 - 03:09:40 CDT