Hi All,
I am new to the Database and practicing the creation of tablespace so, while practicing i got doubt like Alerts on Tablespace usage.
Lets assume that
- Created the local tablespace with size 50m
- Inserted the records till i got error
- Checked the Tablespace used % by using the below Query , its showing 100% full so, altered the tablsespace (autoextend on size unlimited)
SELECT TABLESPACE_NAME TBSP_NAME
, USED_SPACE
, TABLESPACE_SIZE TBSP_SIZE
, USED_PERCENT
FROM SYS.DBA_TABLESPACE_USAGE_METRICS;
I am getting confusion like "When it will get warning on tablespace usage?" since we have used autoextend on size unlimited, it will keep on extending the datafile seems it won't show warning.
Could you please send your valuable solution which will avoid my confusion.
Regards
Narender B