purpose of master and tempdb databases

Hi all,
COuld you pls explain the purpose of master database and tempdb. Can anyone compare this with an oracle database.
Thanks and regards,
Retna
The system databases are well documented in Books Online. Below is a good start:
http://msdn.microsoft.com/library/de...r_da2_1lcx.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Retna" <anonymous@.discussions.microsoft.com> wrote in message
news:A6BD97A2-FE72-4801-B52C-4E9FA44D8DF6@.microsoft.com...
> Hi all,
> COuld you pls explain the purpose of master database and tempdb. Can anyone compare this with an oracle
database.
> Thanks and regards,
> Retna
|||Hi,
Add on to the article mentioned by Tiber , for comparison with Oracle,
SQL Server Oracle
-- --
Master Database System Table Space
Tempdb Temporary tablespace (Where all sort, group, temp
tables operations resides)
So each Oracle database will have a System Table space and Temp table space
during installation itself. This is same as
Master and Tempdb databases in SQL server
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O0SFiQaMEHA.1556@.TK2MSFTNGP10.phx.gbl...
> The system databases are well documented in Books Online. Below is a good
start:
>
http://msdn.microsoft.com/library/de...us/architec/8_
ar_da2_1lcx.asp[vbcol=seagreen]
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Retna" <anonymous@.discussions.microsoft.com> wrote in message
> news:A6BD97A2-FE72-4801-B52C-4E9FA44D8DF6@.microsoft.com...
anyone compare this with an oracle
> database.
>
|||Thanks all.
|||You'll find a lot of info in Books Online and googling. Needless to say,
it's a bit more complicated than this, but...
master is used by SQL Server to store meta data assoicated with the server.
You COULD put user objects here but it is not normally a best practice.
tempdb is recreated from scratch each time the server starts. It's used to
store work tables created by SQL for processing a query and temp tables (#,
##, etc...) you create will go here.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Retna" <anonymous@.discussions.microsoft.com> wrote in message
news:858D968F-7C80-4BA4-8E53-F3CF07B53AC1@.microsoft.com...
> Thanks all.
>
sql