Oracle list tables

Show all tables in oracle

SELECT * FROM ALL_TABLES;

Oracle list tables

SELECT * FROM USER_TABLES;		-- Tables from connected schema
SELECT * FROM ALL_TABLES;		-- Tables available to connected schema
	SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
	SELECT * FROM ALL_TABLES WHERE TABLES_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES;		-- All Tables

Oracle list tablespaces

SELECT DISTINCT TABLESPACE_NAME FROM DBA_EXTENTS ORDER BY TABLESPACE_NAME;

SELECT TABLESPACE_NAME,
       sum(BYTES / 1024 / 1024) AS MB
FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME;

Oracle tablespace tables list

SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs
FROM dba_extents e
WHERE
  e.OWNER = 'MY_USER' AND
  e.TABLESPACE_NAME = 'MY_TABLESPACE'
GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME
ORDER BY e.TABLESPACE_NAME, e.SEGMENT_NAME;

Oracle all tables

-- NOTE: for Oracle ONLY

select * 
from all_tables;

Similar codes

1 vote110 views3 answers
Mysql Server Start
SQL
0 vote127 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
4 votes108 views1 answer
Oracle select first 10 rows
SQL
0 vote102 views1 answer
Select top 3 sql
SQL
0 vote109 views1 answer
Duplicate value unique constraint mysql error
SQL
10 votes109 views2 answers
Sql pagination offset
SQL
0 vote149 views1 answer
Example database query
SQL
2 votes123 views1 answer
How to create sql database
SQL
0 vote117 views1 answer
Alter rename command in mysql
SQL
0 vote99 views1 answer
Close sql query vb.net
SQL