Database Administration (MOSC)

MOSC Banner

ctime and ltime in user$ - reset when migrated from 10g to 11g - how to retain original dates?

edited Apr 17, 2014 11:50AM in Database Administration (MOSC) 10 commentsAnswered ✓

Greetings,

We are migrating an application database from 10g to 11g.  When accessing the dba_users information, I noticed that the created and locked times where being reset to current date, as if the users were being recreated.

I looked in the user$ table as saw that this was the case for both the users and roles being imported.  We would like to retain this history in the new database, because we have individual useris issued and monitered.  Is there an import method that will preserve this like the passwords?  Can we update the ctime and ltime with a simple script run by SYS?  Or would that impact some system login control process?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center