Home » Infrastructure » Linux » Default tablespaces in ORACLE (rhel 5 , 10.2.0)
Default tablespaces in ORACLE [message #556845] Wed, 06 June 2012 23:41 Go to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
Hi to everyone ;

I check tablespace details. I created database by DBCA. Previously i checked tablespace details on my system
It showed only 5 names(SYSTEM , SYSAUX , USERS , TEMPORARY , UNDO)

Today i issued this query please review this i am much confused



SQL> select ts# , name from v$tablespace;

       TS# NAME
---------- ------------------------------
         0 SYSTEM
         1 UNDOTBS1
         2 SYSAUX
         4 USERS
         3 TEMP
         6 EXAMPLE

6 rows selected.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production



** YESTERDAY just showed 5 tablespace names today showing 6 tablespace names
i mean exampe tablespace additionally added. I didn't add anything just created database through DBCA.
* *


Can anyone reply me ???

Thanks and regards
Thiyagusham.G


[EDITED by LF: fixed topic title typo; was "defau;t"]

[Updated on: Thu, 07 June 2012 03:18] by Moderator

Report message to a moderator

Re: Defau;t tablespaces in ORACLE [message #556854 is a reply to message #556845] Thu, 07 June 2012 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Someone added it as Oracle did not add tablespaces.

Quote:
I didn't add anything just created database through DBCA

You cannot create the database if it is already created or do you mean "the only thing you did is to create the database with dbca then you did not do anything (but queried v$tablespace)"?

Regards
Michel
Re: Defau;t tablespaces in ORACLE [message #556861 is a reply to message #556845] Thu, 07 June 2012 01:53 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ Michel
I think you suspect me. I am much confused and i don't understand what oracle does ???

Thanks and Regards
Thiyagusham.G
Re: Defau;t tablespaces in ORACLE [message #556864 is a reply to message #556861] Thu, 07 June 2012 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you answer my question?
What did you exactly do in the exact order of what you did.
I confirm, Oracle does not create tablespace by itself, it only follows the demands we tell it.

Regards
Michel
Re: Defau;t tablespaces in ORACLE [message #556867 is a reply to message #556864] Thu, 07 June 2012 02:11 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ michel

1. I did database creation throgh DBCA
2. I queried V$tablespace and dba_tblespaces;

" please review attached screen shot "

Thanks
  • Attachment: tsb.png
    (Size: 330.24KB, Downloaded 86 times)
Re: Defau;t tablespaces in ORACLE [message #556877 is a reply to message #556867] Thu, 07 June 2012 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So when happens the new tablespace? In what you posted you query the view only once.

Regards
Michel
Re: Defau;t tablespaces in ORACLE [message #556934 is a reply to message #556877] Thu, 07 June 2012 07:07 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ michel

Recently i saw oracle corp document they explained step by step regarding tablespaces. right now unable to find the document. I mean URL could n't find out.
I need good clarity for LMT Vs DMT in oracle tablespaces.

"Quote:
The storage parameters NEXT, PCTINCREASE, MINEXTENTS, MAXEXTENTS, and DEFAULT STORAGE are not valid for extents that are managed locally ! "



SQL> select initial_extent,min_extents,max_extents from dba_tablespaces where tablespace_name='USERS';

INITIAL_EXTENT MIN_EXTENTS MAX_EXTENTS
-------------- ----------- -----------
         65536           1  2147483645

SQL> select pct_increase, next_extent from dba_tablespaces where tablespace_name='USERS';

PCT_INCREASE  NEXT_EXTENT
------------  -----------



may i know what are the parameters are valid for LMT as well as DMT.

Thanks and Regards
Thiyagu.G

" I need some clear document for LMT and DMT "

Thanks and Regards
Thiyagusham.G
Re: Defau;t tablespaces in ORACLE [message #556993 is a reply to message #556934] Fri, 08 June 2012 00:19 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
as per my experience when we create the database by using the dbca it automatically create all the tablespace that is ( SYSTEM UNDOTBS1 SYSAUX USERS TEMP EXAMPLE ). u must had done the mistake when u seen it first time. (because i configure database many time by the dbca and all time it create all the tablespace that maintain above).

thanks & regards
pritsh ranjan

Re: Defau;t tablespaces in ORACLE [message #556996 is a reply to message #556993] Fri, 08 June 2012 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
That's a good guess.

Regards
Michel
Re: Defau;t tablespaces in ORACLE [message #556997 is a reply to message #556934] Fri, 08 June 2012 01:15 Go to previous message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I need good clarity for LMT Vs DMT in oracle tablespaces.


New question, new topic, do NOT mix up different subjects.
Create a new topic for this but, first, read Database Concepts as this is answered in it.

Regards
Michel

[Updated on: Fri, 08 June 2012 01:17]

Report message to a moderator

Previous Topic: os autentication error
Next Topic: external table error
Goto Forum:
  


Current Time: Sat Nov 22 22:53:44 CST 2014

Total time taken to generate the page: 0.10961 seconds