Home » RDBMS Server » Server Administration » Oracle Tablespace Datafile Who Created (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.17.0.0.0)
Oracle Tablespace Datafile Who Created [message #687438] Thu, 09 March 2023 07:33 Go to next message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
How do I check who have created the datafile on a tablespace? The views dba_data_files and v$datafile does not have any info about it. Please advise.

Thank you,
Warren
Re: Oracle Tablespace Datafile Who Created [message #687439 is a reply to message #687438] Thu, 09 March 2023 07:57 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you have configured audit on DDL or on privilege to create the datafile you have this in DBA_AUDIT% views.
Otherwise you have to mine the log files (Log Miner).

[Updated on: Thu, 09 March 2023 08:32]

Report message to a moderator

Previous Topic: Audit Logon of Specific User
Next Topic: Create Audit Policy on Package (Unified Auditing)
Goto Forum:
  


Current Time: Thu Mar 28 14:20:34 CDT 2024