select any dictionary与select_catalog_role区别(二)
ole set.
test@TEST0924> select file_id,file_name,tablespace_name from dba_data_files;
FILE_ID FILE_NAME TABLESPACE_NAME
---------- -------------------------------------------------- ------------------------------
4 +DATA/test0924/datafile/users.260.829650045 USERS
3 +DATA/test0924/datafile/inventory.266.829658135 INVENTORY
2 /u01/app/oracle/oradata/test0924/sysaux01.dbf SYSAUX
1 /u01/app/oracle/oradata/test0924/system01.dbf SYSTEM
5 /u01/app/oracle/oradata/test0924/example01.dbf EXAMPLE
6 +DATA/test0924/datafile/inventory03.dbf INVENTORY
8 /u01/app/oracle/oradata/test0924/undotbs02.dbf UNDOTBS2
9 /u01/app/oracle/oradata/test0924/undotbs01.dbf UNDOTBS1
10 /u01/app/oracle/oradata/test0924/inventory01.dbf INVENTORY
9 rows selected.
4、必须使用set role，才能及时生效。