SQL> conn scott/tiger
Connected.
SQL> SELECT TABLESPACE_NAME, FILE_ID, BYTES FROM USER_FREE_SPACE WHERE TABLESPACE_NAME IN ('USERS', 'ABDULWASIQ');
TABLESPACE_NAME FILE_ID BYTES
------------------------- ---------- ----------
ABDULWASIQ 7 9371648
USERS 5 208666624
USERS 4 3866624
SQL>
Connected.
SQL> SELECT TABLESPACE_NAME, FILE_ID, BYTES FROM USER_FREE_SPACE WHERE TABLESPACE_NAME IN ('USERS', 'ABDULWASIQ');
TABLESPACE_NAME FILE_ID BYTES
------------------------- ---------- ----------
ABDULWASIQ 7 9371648
USERS 5 208666624
USERS 4 3866624
SQL>
No comments:
Post a Comment