EXPIRY_DATE

 

I created a tablespace called "TABSP_X", then I created a user called "XX" using the command

create user "XX" identified by "XX_Password" default tablespace "TABSP_X";

on 2 servers the first called SERVER1 runs oracle 9i and the second called SERVER2 runs oracle 11g release2

the user created on the 2 servers but after I made examine for the view dba_users on the 2 servers, I found

on SERVER1 

SELECT USERNAME,EXPIRY_DATE,DEFAULT_TABLESPACE FROM dba_users WHERE username = "XX" ;

I got

USERNAME,  EXPIRY_DATE,    DEFAULT_TABLESPACE

XX                                                  TABSP_X

on SERVER2

SELECT USERNAME,EXPIRY_DATE,DEFAULT_TABLESPACE FROM dba_users WHERE username = "XX" ;