data dictionary views

[nunnasujatha]

Hi all,

I know that using dba_data_files we can view all the datafiles created by the users.


But what data dictionary view will help us to know the data files created by the particularuser? ???


Thanks In Advance

[pragatiswain]

Hi all,
I know that using dba_data_files we can view all the datafiles created by the users.
But what data dictionary view will help us to know the data files created by the particularuser? ???
Thanks In Advance

Check:
ALL_DATA_FILES, USER_DATA_FILES , V$DATAFILE

[nunnasujatha]

i tried these before also n i'm using ORACLE 9.2 version.the errors are


SQL> desc all_data_files;
ERROR:
ORA-04043: object all_data_files does not exist


SQL> desc user_data_files ;
ERROR:
ORA-04043: object user_data_files does not exist


SQL> desc v$datafiles;
ERROR:
ORA-04043: object v$datafiles does not exist

[pragatiswain]

i tried these before also n i'm using ORACLE 9.2 version.the errors are

SQL> desc all_data_files;
ERROR:
ORA-04043: object all_data_files does not exist

SQL> desc user_data_files ;
ERROR:
ORA-04043: object user_data_files does not exist

SQL> desc v$datafiles;
ERROR:
ORA-04043: object v$datafiles does not exist

I am not much experienced in this as I am just a user, not a DBA.
May be the object user_data_files is not there as that user didn't create any tablespace/ doesn't have priviledge to create table space.

[suvam]

Check whether there is any column called OWNER in the DBA_DATA_FILES .

[nunnasujatha]

there is no column like owner in dba_data_fiels

[buzznt]

There is no track on which user created which database object unless U activate the "audit" option (taking into account that it will effect your DB performance) and then get a log for every operation in the DB.

Only take into account that only users with DBA privilege can create datafile.

10X,

Roni