Friday, March 21, 2014

Find Tablespace used by Oracle Schema

1.  Login to Database using Schema User
2. Execute below query

SELECT TABLESPACE_NAME "TABLESPACE",
   INITIAL_EXTENT "INITIAL_EXT",
   NEXT_EXTENT "NEXT_EXT",
   MIN_EXTENTS "MIN_EXT",
   MAX_EXTENTS "MAX_EXT",
   PCT_INCREASE
   FROM USER_TABLESPACES;

No comments:

Post a Comment