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
Please feel free to correct me if there are any errors in the blog. I am writing this blog for my reference and understanding.
Monday, 17 July 2017
Subscribe to:
Post Comments (Atom)
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...
-
Oracle 11g Hidden Database Parameters ============================= [oracle@dev ~]$ sqlplus / as sysdba; SQL*Plus: Release 11.2.0.3.0 Prod...
-
Softwares Required to install WebLogic Server: 1. jdk-8u121-windows-x64.exe (for development) or jrockit-jdk1.6.0_45-R28.2.7-4.1.0-w...
-
Docker Installation on AWS EC2 ``` sudo apt install docker.io sudo systemctl enable --now docker docker -v ``` Other way to Install...
No comments:
Post a Comment