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: 422
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

Report message to a moderator

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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 08 18:33:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.