Home » SQL & PL/SQL » SQL & PL/SQL » oracle tablespace
oracle tablespace [message #220573] Wed, 21 February 2007 05:19 Go to next message
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
Re: oracle tablespace [message #220578 is a reply to message #220573] Wed, 21 February 2007 05:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: oracle tablespace [message #220611 is a reply to message #220573] Wed, 21 February 2007 06:56 Go to previous messageGo to next message
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 444 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 Go to previous message
William Robertson
Messages: 1640
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.
Previous Topic: Order By Trouble
Next Topic: Populate Drop Down list with query results
Goto Forum:
  


Current Time: Thu Dec 08 00:34:32 CST 2016

Total time taken to generate the page: 0.10743 seconds