Oracle list tablespaces

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;

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

0 vote342 views1 answer
Add timestamp column to existing table ms sql server
SQL
1 vote358 views2 answers
List tables sqlalchemy
SQL
1 vote341 views1 answer
How to give access to database in postgresql server to another user
SQL
12 votes364 views6 answers
Select distinct
SQL
10 votes338 views3 answers
Insert into auto increment mysql
SQL
0 vote348 views1 answer
Mysql group by range
SQL
4 votes328 views2 answers
How to count items with same name in sql
SQL
1 vote345 views2 answers
How to check username in mysql command line
SQL
3 votes464 views1 answer
Sql select second max
SQL
16 votes373 views6 answers
Python sqlite
SQL