users / password file clarification

From: Paul Murphy <pmurphy_at_scsinet.com>
Date: 3 May 2004 10:37:55 -0700
Message-ID: <b6ab6d71.0405030937.70cddfec@posting.google.com>

I just want to be sure I'm clear about recovering user accounts from a backup, since it's not covered in the OCP books. Hopefully, each of the following statements is true, if not, please let me know.

If you have only DBA accounts in the password file, the regular users are stored in the system tablespace.

If you add regular users after the system tablespace is backed up and have to restore the system tablespace data file and roll forward using the redo logs, the user accounts will be recreated when the user table in the system tablespace is rolled forward.

What I'm wondering is:

Is a create user statement just a DML insert into a table and will be rolled forward like any other insert statement?

Thanks for clearing this up for me.
Paul Murphy Received on Mon May 03 2004 - 12:37:55 CDT