Search code examples
sqloracle-databaseschemacreation

Oracle: Timestamp when schema has been created?

is there a possibility via SQL to get the timestamp when a schema (for example SYS) has been created?

Background:

Actually, I want to get the timestamp when I initially setup the whole DB cluster: I regularly delete and recreate it via dbca and import DB backups. So I'm interested when this process happend the last time.

Solution

  • Ok, found the solution myself: select created from all_users where username = 'someuser' works for me.