Monday 17 July 2017

how to view datafiles available in tablespace

FETCH ALL DATAFILES WITH TABLESPACE NAME:
-----------------------------------------
col tablespace_name format a16;
col file_name format a36;
SELECT TABLESPACE_NAME, FILE_NAME, BYTES FROM DBA_DATA_FILES;


FETCH DATAFILES AVAILABLE IN TABLESPACE:
----------------------------------------
select file_name from dba_data_files where tablespace_name='PSIMAGE';

FILE_NAME
--------------------------------------------------------------------------------
+ORA_DB/hrprd/datafile/psimage.221.81503
+ORA_DB/hrprd/datafile/psimage.450.97645
+ORA_DB/hrprd/datafile/psimage.589.94091


FETCH DATAFILE SPACE, MAXIMUM SPACE, AUTOEXTEND OF DATAFILE:
-----------------------------------------------------------
set linesize 124
col file_name format a60
col AUTOEXTENSIBLE format a18
SELECT FILE_NAME, BYTES/(1024*1024), MAXBYTES/(1024*1024), AUTOEXTENSIBLE from DBA_DATA_FILES
WHERE TABLESPACE_NAME='PSIMAGE';

FILE_NAME BYTES/(1024*1024) MAXBYTES/(1024*1024) AUTOEXTENSIBLE
--------------------------------- ----------------- -------------------- ------------------
/u01/oradata/hrdemo/psimage.dbf 1813 32767.9844 YES

No comments:

Post a Comment

Jenkins Startup and Configuration

Steps to setup jenkins on ubuntu:- -After installation. check the jenkins services running on not on the server. sudo service jenk...