Oracle Notes & Tips

To Check Datafile size

• SELECT * FROM DBA_DATA_FILES;

To Check Database User/Owner

• SELECT * FROM DBA_USERS;

To change user's default Tablespace

• ALTER USER <USER> DEFAULT TABLESPACE <TABLESPACE_NAME>