Re: Another newbie tablespace question
From: Sean Fitzgerald <sfitzgerald_at_centurytel.net>
Date: 4 Sep 2001 11:42:01 -0700
Message-ID: <605a2fd5.0109041042.33de3785_at_posting.google.com>
Date: 4 Sep 2001 11:42:01 -0700
Message-ID: <605a2fd5.0109041042.33de3785_at_posting.google.com>
- Any version that is at least 8.1 and less that 9.0 is 8i. So you are running 8i.
- You may see the objects in a tablespace by looking in the view dba_tables. select object_name, object_type from dba_tables where tablespace_name = 'xxxx'
- There are many views and tables that contain valuable information so you should spend some time reading the Oracle docs to familiarize yourself which them. There are also many vendors of third-party software that give away good posters with the v$ and data dictionary views (for quick reference).