tablespace oracle

Solutions on MaxInterview for tablespace oracle by the best coders in the world

showing results for - "tablespace oracle"
Jacopo
07 Jun 2018
1SELECT DISTINCT TABLESPACE_NAME FROM DBA_EXTENTS ORDER BY TABLESPACE_NAME;
2
3SELECT TABLESPACE_NAME,
4       sum(BYTES / 1024 / 1024) AS MB
5FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME;
Jonathan
20 Sep 2017
1-- Size and usage of tablespaces
2SELECT T1.TABLESPACE_NAME,
3       T1.BYTES / 1024 / 1024   as                        "bytes_used (Mb)",
4       T2.BYTES / 1024 / 1024   as                        "bytes_free (Mb)",
5       T2.largest / 1024 / 1024 as                        "largest (Mb)",
6       round(((T1.BYTES - T2.BYTES) / T1.BYTES) * 100, 2) percent_used
7FROM (
8         select TABLESPACE_NAME,
9                sum(BYTES) BYTES
10         from dba_data_files
11         group by TABLESPACE_NAME
12     ) T1,
13     (
14         select TABLESPACE_NAME,
15                sum(BYTES) BYTES,
16                max(BYTES) largest
17         from dba_free_space
18         group by TABLESPACE_NAME
19     ) T2
20where T1.TABLESPACE_NAME = T2.TABLESPACE_NAME
21order by ((T1.BYTES - T2.BYTES) / T1.BYTES) desc;
Luca
12 Jul 2016
1SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs
2FROM dba_extents e
3WHERE
4  e.OWNER = 'MY_USER' AND
5  e.TABLESPACE_NAME = 'MY_TABLESPACE'
6GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME
7ORDER BY e.TABLESPACE_NAME, e.SEGMENT_NAME;
Eric
23 Feb 2016
1CREATE TABLESPACE
2TBS_NOME_TABLESPACE
3DATAFILE 'NOME_DATAFILE.dbf' SIZE 40M ONLINE;
Elaine
16 Aug 2017
1CREATE TABLE TB_NOME_TABELA
2(
3CODIGO NUMBER(38)
4)TABLESPACE TBS_NOME_TABLESPACE;
queries leading to this page
oracle sql developer create tableoracle system tablespace fulltablespace with example in oracle19cwhat is a tablespace in oracleoracle tablespace usage queryoracle what is a tablespacepermanent tablespace in oracleoracle all tablespaceswhat is tablespace in oracleoracle tablespace usage by objectoracle tablespace list sqltablespace structure oraclewhen tablespace created in oraclewhat is an oracle tablespaceoracle tablespace listoracle see tablespacescheck tablespace in oraclewhat are the tablespaces in oracleoracle tablespace usageselect tablespace oracleadvantage of using tablespace oracleget tablespace in oraclewhy to use tablespace oracleselect all tablespace from database oracleoracle select tablespaceoracle show tablespacestable and tablespace in oracle19cshow tablespaces oracleoracle tablespace querytablespace history usage oracleoracle tables listwhat is sysaux tablespace in oracleextents in oracle tablespacetablespace oracle d c3 a9finitionoracle tablespacesoracle db list tableslist tables sql oracleselect 2a tablespace oracleoracle tables in tablespaceoracle list all tableswho use system tablespace in oracleoracle 9i tablespace usagetablespaces size oracleoracle list tablesoracle tablespace propertiesdrop tablespace oracleoracle how to create tablespacetablespaces oracletable and tablespace in oracleoracle list tablespacestablespaces oracle queryoracle get tablespace infotablespaceview tablespaces oracletablespaces in oracleoracle show tablespace nameswhy tablespace is required in oracleoracle database link list tablesoracle show all tablespacesselect tablespace in oraclehow to know the tablespaces in oracletablespace oracleavailable tablespace in oracleoracle tablespace tables listtablespace management in oracleoracle get current tablespace usageoracle list tablespacetablespace usage in oracletablespace in oracletable spacetablespace usage script oracleoracle how to get tablespacesystem tablespace in oracle fulloracle tablespaceliquibase oracle tablespaceoracle tablespace datacreate user pdv interface identified by juno 2020 default tablespace dadostablespace oracle