Single user logon in Database

[gschuah]

Hi,
I am trying to do an export from my database. But I just wonder whether I can block other user to logon in my database during the process. I had tried using 'startup mount' but it did't work. Would be appreciate all kind of your advise.
Thank you in advance

[ckwan]

One way I can think of is to lock the user account.
Write a script to lock all the users' account.
'alter user account lock;' command then run the spooled file generated. Of course this script u want to exclude from SYSTEM and SYS user.

Then you can use SYSTEM user to proceed with ur export backup.

Any other option are very welcome to post over here.

[santoshym]

Hi

Start the database in restricted mode

startup restrict

then use a user with

restricted session

privilege to perform the export

Regards,
Santosh

[ckwan]

Yup! Satoshym is right.

[gschuah]

Thanks buddy. Will try to do it!