SQL> column file# format a10
SQL> column TO_CHAR format a60
SQL> column FILE_NAME format a30
SQL> set linesize 150
SQL> SELECT TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI:SS') FROM dual;
SQL> SELECT FILE# file_nr, TO_CHAR(CHECKPOINT_TIME,'DD/MM/YYYY HH24:MI:SS') checkpoint_time, NAME file_name
FROM v$datafile_header;
FILE_NR CHECKPOINT_TIME FILE_NAME
---------- ------------------- ------------------------------------------------------------
1 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/system01.dbf
2 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/sysaux01.dbf
3 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/undotbs01.dbf
4 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/users01.dbf
5 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/example01.dbf
SQL> column TO_CHAR format a60
SQL> column FILE_NAME format a30
SQL> set linesize 150
SQL> SELECT TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI:SS') FROM dual;
TO_CHAR(SYSDATE,'DD
-------------------
05/02/2016 09:22:48
SQL> SELECT FILE# file_nr, TO_CHAR(CHECKPOINT_TIME,'DD/MM/YYYY HH24:MI:SS') checkpoint_time, NAME file_name
FROM v$datafile_header;
FILE_NR CHECKPOINT_TIME FILE_NAME
---------- ------------------- ------------------------------------------------------------
1 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/system01.dbf
2 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/sysaux01.dbf
3 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/undotbs01.dbf
4 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/users01.dbf
5 05/02/2016 09:22:19 /u01/app/oracle/oradata/prim/example01.dbf
No comments:
Post a Comment