OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » USERS tablespace (10g,SunOS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

USERS tablespace [message #541421]

Tue, 31 January 2012 03:13

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I heard that USERS tablespace should not contain any other application schema objects.

If the above statements is true , can somebody explain why it should not contain other schema objects ?

Thank you

Report message to a moderator

Re: USERS tablespace [message #541423 is a reply to message #541421]

Tue, 31 January 2012 03:23

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You should use USERS tablespace because it is a tablespace for Oracle example schemas.
Create your own tablespaces (and drop USERS one in all databases but learning ones).

Regards
Michel

Report message to a moderator

Re: USERS tablespace [message #541435 is a reply to message #541423]

Tue, 31 January 2012 04:25

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

You should use USERS tablespace because it is a tablespace for Oracle example schemas.

what are oracle example schemas ?

Thank you

Report message to a moderator

Re: USERS tablespace [message #541436 is a reply to message #541435]

Tue, 31 January 2012 04:37

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SCOTT, HR, OE, PM, SH...

Regards
Michel

[Updated on: Tue, 31 January 2012 12:05]

Report message to a moderator

Re: USERS tablespace [message #541484 is a reply to message #541436]

Tue, 31 January 2012 11:51

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Michel,

I understood something about USERS tablespace but not fully like

1.Would there be any impact to database/application if we create other schema objects
in USERS tablespace?

2.Is it still necessary to move the schema objects to other tablespace if it exist
in USERS tablespace?

I am looking for the answer in detail.

Thank you

Report message to a moderator

Re: USERS tablespace [message #541485 is a reply to message #541484]

Tue, 31 January 2012 12:07

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1. What will happen if Oracle decides to change the way USERS tablespace is managed? or even to drop it?
2. This is my opinion, see 1.

Regards
Michel

[Updated on: Tue, 31 January 2012 12:08]

Report message to a moderator

Re: USERS tablespace [message #541488 is a reply to message #541485]

Tue, 31 January 2012 12:27

John Watson
Messages: 8996
Registered: January 2010
Location: Global Village

Senior Member

I would go for a less technical reason for not using USERS. I see the USERS tablespace in many client databases, and I always assume that it is just a bit of scratch storage in which I (or anyone else) can do what they like, and that it doesn't get any proper monitoring or management.
So I would say that if you don't use it that way, drop it.

Report message to a moderator

Re: USERS tablespace [message #541636 is a reply to message #541488]

Wed, 01 February 2012 07:10

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you .

Report message to a moderator

Previous Topic:	Hybrid Columnar Compression: useful bug
Next Topic:	Unable to increase the size of sga

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 17 18:34:28 CST 2026