Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle list data files

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 :: get the mysql table columns data type mysql 
Sql :: create procedure with encryption 
Sql :: load mysql dumb 
Sql :: oracle check numeric 
Sql :: scaffold npgsql net core 
Sql :: oracle session date format 
Sql :: oracle get nls settings 
Sql :: oracle sql first day of year 
Sql :: update substring in mysql 
Sql :: sql get table last modified time 
Sql :: sql list users and roles 
Sql :: oracle split string 
Sql :: split first name and last name in sql 
Sql :: mysql show tables in database 
Sql :: how to see all table partition in oracle 
Sql :: select sql in descending order 
Sql :: get all table names in sql 
Sql :: sql drop table statement 
Sql :: reset sql auto increment 
Sql :: view linked servers sql 
Sql :: oracle create program if no exists 
Sql :: mysql change primary key 
Sql :: Syntax of for-loop in SQL Server 
Sql :: using distinct count in sqlite3 
Sql :: centos 8 install mysql 
Sql :: if not exists insert sql 
Sql :: sql add months to date 
Sql :: join to find results not in another table 
Sql :: this is incompatible with sql_mode=only_full_group_by laravel 
Sql :: mysql order by desc null last 
ADD CONTENT
Topic
Content
Source link
Name
1+2 =