OraFAQ Forum: SQL & PL/SQL » oracle tablespace

Home » SQL & PL/SQL » SQL & PL/SQL » oracle tablespace

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

oracle tablespace [message #220573]

Wed, 21 February 2007 05:19

gauri.w
Messages: 2
Registered: December 2006

Junior Member

Hi,
I have a query. Can u pls let me know whether 'user' or 'users' is the tablespace predefined in Oracle??

thanks,
Gauri

Report message to a moderator

Re: oracle tablespace [message #220578 is a reply to message #220573]

Wed, 21 February 2007 05:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It is not essentially predefined. When you use the default options with DBCA, users tablespace is included.

Report message to a moderator

Re: oracle tablespace [message #220611 is a reply to message #220573]

Wed, 21 February 2007 06:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Mahesh already give you answer It is USERS not USER.

and instead of this when we create database in Oracle 10g.
Default tablespace creation are >
1. SYSTEM.
2. SYSAUX
3. UNDOTBS
4. TEMP
5. USERS

see attach documents for above tablespace DEFAULT size.

If you don't select SAMPLE schema.

Attachment: Doc1.doc
(Size: 135.00KB, Downloaded 818 times)

[Updated on: Wed, 21 February 2007 07:22]

Report message to a moderator

Re: oracle tablespace [message #220696 is a reply to message #220573]

Wed, 21 February 2007 10:31

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

You can't easily name a tablespace "USER" as there is already a function with that name.

Report message to a moderator

Previous Topic:	Order By Trouble
Next Topic:	Populate Drop Down list with query results

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 18:10:03 CST 2024