Home » RDBMS Server » Server Administration » Oracle Tablespace Datafile Who Created (Oracle Database 19c Enterprise Edition Release - Production Version
Oracle Tablespace Datafile Who Created [message #687438] Thu, 09 March 2023 07:33 Go to next message
Messages: 404
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,
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: 68658
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: Wed May 29 15:34:26 CDT 2024