Database Utilities (MOSC)

MOSC Banner

Alter Database Resize Does Not Resize the Datafile at the OS Level

edited Oct 7, 2010 8:00PM in Database Utilities (MOSC) 3 commentsAnswered ✓
 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*

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center