root>su - oracle

root>export ORACLE_SID = hrms

root>sqlplus / as sysdba

 

SQL>startup

SQL>desc dba_users;

SQL>select * from all_users;

                Lists all the existing users.

SQL>select username,default_tablespace,temporary_tablespace,profile from dba_users where            

username='SCOTT';

                                List the default tablespace for the given username.