Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

What is the standard way of only allowing a single login during an Oracle 9i database export to prevent others from modifying the database during or after the export?

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

You can use restricted mode to keep everyone off who does not have RESTRICTED_SESSION privileges:

ALTER SYSTEM ENABLE RESTRICTED SESSION;

This does not prevent other users with this privilege from logging on.

share|improve this answer
    
Will this disconnect current sessions of those who do not have RESTRICTED_SESSION, or will it only prevent logon? –  Steven Feb 3 '10 at 20:17
    
I believe it only prevents new logons. Typically, you would shutdown the instance, and bring it back up in restricted mode. You can even specify to startup the instance in restricted mode: STARTUP RESTRICT; –  DCookie Feb 3 '10 at 22:51
1  
If one were only worried about making sure the export was consistent to a single point in time, the CONSISTENT=Y option can be set. –  Adam Musch Sep 2 '10 at 15:09
add comment

Why would one need to? An export in CONSISTENT mode would take an export as of the SCN when the export kicked off; functionally equivalent to:

SET TRANSACTION READ ONLY;
SELECT FROM TABLE1;
SELECT FROM TABLE2;
.
.
.
share|improve this answer
1  
I am performing the final export (and subsequent import) onto a new server to replace the current one. I need to be sure no information was put into the old database after I started the export. –  Steven Mar 12 '10 at 20:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.