Alter Database Resize Does Not Resize the Datafile at the OS Level
Status for resize on Oracle-Level
Status Tablespace Name TS Type Ext. Mgt. Seg. Mgt. Tablespace Size Used (in bytes) Free (in bytes) Pct. Used
--------- --------------- ------------ ---------- --------- ------------------ ------------------ ------------------ ---------
ONLINE AGING_000010000 PERMANENT LOCAL AUTO 124,977,152 25,952,256 99,024,896 21
Status after resize Oracle-Level
Check Database:
Status Tablespace Name TS Type Ext. Mgt. Seg. Mgt. Tablespace Size Used (in bytes) Free (in bytes) Pct. Used
--------- --------------- ------------ ---------- --------- ------------------ ------------------ ------------------ ---------
ONLINE AGING_000010000 PERMANENT LOCAL AUTO 25,960,448 25,960,448 0 100
Status file system for resize on OS-Level: HP-UX sv648 B.11.31:
oracle@sv648:MAXAVA00 > pwd
/d2000/oradata/MAXAVA00
oracle@sv648:MAXAVA00 > ls -la AGING_000010000*
Status Tablespace Name TS Type Ext. Mgt. Seg. Mgt. Tablespace Size Used (in bytes) Free (in bytes) Pct. Used
--------- --------------- ------------ ---------- --------- ------------------ ------------------ ------------------ ---------
ONLINE AGING_000010000 PERMANENT LOCAL AUTO 124,977,152 25,952,256 99,024,896 21
Status after resize Oracle-Level
Check Database:
Status Tablespace Name TS Type Ext. Mgt. Seg. Mgt. Tablespace Size Used (in bytes) Free (in bytes) Pct. Used
--------- --------------- ------------ ---------- --------- ------------------ ------------------ ------------------ ---------
ONLINE AGING_000010000 PERMANENT LOCAL AUTO 25,960,448 25,960,448 0 100
Status file system for resize on OS-Level: HP-UX sv648 B.11.31:
oracle@sv648:MAXAVA00 > pwd
/d2000/oradata/MAXAVA00
oracle@sv648:MAXAVA00 > ls -la AGING_000010000*
0