CREATE TABLESPACE hr_tablespace
DATAFILE '+DATA001/App/DATAFILE/datafile.001.0000001' SIZE 60M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
using a query to get info from the dba views or data dictionary views. which views/tables and columns should i use to get the info based on the DDL above? so far what i have is this
select tablespace_name,
FILE_NAME,
BYTES/(1024*1024) filesize,
MAXBYTES/(1024*1024) maxbytes,
increment_by/(1024*1024) increment_by,
AUTOEXTENSIBLE
from DBA_DATA_FILES
where tablespace_name;

but it still missing info on how i can get the MAXSIZE and unlimited. please advise. thanks.
[Updated on: Mon, 09 September 2019 12:58]
Report message to a moderator