- Which tables do you have?
SQL> select table_name from user_tables;
- How is my table defined, which columns has it?
SQL> describe table_name
- Which database objects do I have currently?
SQL> select object_name, object_type from user_objects;
- Which privileges has your Oracle account?
SQL> select * from session_privs;
- Which quota do you actually have on which tablespace?
SQL> select tablespace_name, bytes, max_bytes from user_ts_quotas;
- How big are your tables/objects for themselves?
-
SQL> select segment_name, tablespace_name, bytes from user_segments;