Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle list datafiles in tablespace

SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'tbs_name' ORDER BY FILE_NAME;
Comment

Oracle list datafiles

SELECT
FILE_NAME, 
BLOCKS, 
TABLESPACE_NAME
FROM DBA_DATA_FILES;
Comment

PREVIOUS NEXT
Code Example
Sql :: postgres check timezone 
Sql :: function difference_in_hours(timestamp with time zone) does not exist 
Sql :: host is not allow to connect to this mysql server 
Sql :: table infromation in sql server 
Sql :: set boolean flasksql 
Sql :: oracle set date format 
Sql :: DUPLICATE column values 
Sql :: How to select the nth row in a SQL database table? 
Sql :: sql output inserted id 
Sql :: how to check mysql version in xampp 
Sql :: how to insert string variable into sqlite database 
Sql :: remove password from root mysql 
Sql :: create column mysql terminal 
Sql :: how to describe a table in sqlite3 
Sql :: ALL_TAB_PARTITIONS 
Sql :: truncate table 
Sql :: the package java.sql is not accessible 
Sql :: drop table in mysql 
Sql :: reset auto increment in mysql 
Sql :: finding duplicate rows mysql 
Sql :: varchar plsql 
Sql :: sql drop database statement 
Sql :: create mysql user on all hosts 
Sql :: how to get table current identity value in sql server 
Sql :: wsl centos 8 mysql 
Sql :: désinstaller postgresql linux 
Sql :: How to reset forgotten postgresql password 
Sql :: SQL SERVER SELECT BETWEEN DATETIME 
Sql :: sql server current date 
Sql :: show columns in sql 
ADD CONTENT
Topic
Content
Source link
Name
5+6 =