Answers for "check available tablespace in oracle sql"

SQL
2

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;
Posted by: Guest on June-17-2021
-1

Tablespace ORACLE

CREATE TABLE TB_NOME_TABELA
(
CODIGO NUMBER(38)
)TABLESPACE TBS_NOME_TABLESPACE;
Posted by: Guest on September-28-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language