SQL> create user harry identified by harry;
User created.
SQL> grant CREATE SESSION, SELECT ANY TABLE, SELECT ANY DICTIONARY TO harry;
Grant succeeded.
SQL> conn harry@test
Enter password: *****
Connected.
SQL> desc dba_free_space;
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLESPACE_NAME VARCHAR2(30)
FILE_ID NUMBER
BLOCK_ID NUMBER
BYTES NUMBER
BLOCKS NUMBER
RELATIVE_FNO NUMBER
SQL> select * from dba_free_space
2 where rownum <4;
TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS
------------------------------ ---------- ---------- ---------- ----------
RELATIVE_FNO
------------
SYSTEM 1 10021 32768 4
1
SYSTEM 1 8444 49152 6
1
SYSTEM 1 18369 85458944 10432
1
I remember when this place was cool.