Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tablespace usage

Aspire_DBAJul 7 2011 — edited Jul 7 2011
Hi,
Im seeing the details of table spaces used in a DB, noticed that *'USERS'* is a tablespace used for posting transactions.
I suppose USERS is a tablespace used by database. Is there any impact on such a setting.


SQL> select banner from V$VERSION;

BANNER
-----------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production



SELECT default_tablespace FROM DBA_USERS WHERE username = 'TEST'

DEFAULT_TABLESPACE
------------------------------
USERS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2011
Added on Jul 7 2011
#general-database-discussions
3 comments
353 views