Oracle tablespace tables list

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 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;

Tablespace ORACLE

CREATE TABLESPACE
TBS_NOME_TABLESPACE
DATAFILE 'NOME_DATAFILE.dbf' SIZE 40M ONLINE;

-1

Source: devmedia.com.br

Tablespace ORACLE

CREATE TABLE TB_NOME_TABELA
(
CODIGO NUMBER(38)
)TABLESPACE TBS_NOME_TABLESPACE;

-1

Source: devmedia.com.br

Similar codes

3 votes258 views2 answers
Monthname sql
SQL
0 vote293 views1 answer
Declare or use variable in snowflake
SQL
10 votes236 views2 answers
Mysql select timestamp group by day
SQL
11 votes271 views5 answers
Laravel db facade
SQL
1 vote251 views1 answer
Oracle apex run 404
SQL
0 vote248 views1 answer
Get server date mysql
SQL
0 vote242 views1 answer
Oracle execute immediate quotes
SQL
0 vote253 views1 answer
Limit and offset in stored procedure mssql
SQL
11 votes259 views5 answers
How to install sqlite3 python
SQL
16 votes276 views2 answers
Mysql date between two dates
SQL