Use prompt to display information
SQL>
SQL>
SQL> prompt
SQL> prompt This is a list of users and their default
This is a list of users and their default
SQL> prompt tablespaces
tablespaces
SQL>
SQL> select username, default_tablespace
2 from dba_users
3 where rownum < 50
4 /
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
SYS SYSTEM
SYSTEM SYSTEM
ANONYMOUS SYSAUX
MDSYS SYSTEM
OUTLN SYSTEM
DIP SYSTEM
TSMSYS SYSTEM
FLOWS_FILES SYSAUX
CTXSYS SYSAUX
DBSNMP SYSAUX
FLOWS_020100 SYSAUX
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
XDB SYSAUX
HR USERS
13 rows selected.
SQL>
SQL>
Related examples in the same category