pdb queries
set lines 333 col tablespace_name for a30 col contents for a25 col status for a15 col con_name for a20 select c.con_id, c.name con_name, t.tablespace_name, t.contents, t.status from v$containers c, cdb_tablespaces t where c.con_id=t.con_id order by 1,2; ---------------------------------------------------------------------------------------------------------- set lines 400 col con_name for a20 col username for a25 col account_status for a28 -- col LOCK_DATE -- col EXPIRY_DATE -- col LAST_LOGIN col DEFAULT_TABLESPACE for a25 col TEMPORARY_TABLESPACE for a15 --col LOCAL_TEMP_TABLESPACE for a15 col PROFILE for a25 select c.con_id, c.name con_name, u.username,u.account_status,u.common,u.default_tablespace,u.temporary_tablespace,u.profile from v$containers c, cdb_users u where c.con_id=u.con_id order by 1,2; ---------------------------------------------------------------------------------------------------------- set lines 400 col file_name for a66 col...