OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Default tablespace

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

Default tablespace [message #208164]

Fri, 08 December 2006 07:04

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

i have created a database.but when i create any users without specifying default tablespace,it is taking system as default tablespace.how to set a default tablespace for all users ?

i checked the 10g docs, but it always says about BIGFILE SMALL FILE concepts.can anyone help me

Report message to a moderator

Re: Default tablespace [message #208169 is a reply to message #208164]

Fri, 08 December 2006 07:16

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Did you try:

ALTER DATABASE DEFAULT TABLESPACE <new_tablespace_name>;

Report message to a moderator

Re: Default tablespace [message #208170 is a reply to message #208164]

Fri, 08 December 2006 07:20

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

that worked.thanks

Report message to a moderator

Previous Topic:	obsolete and/or deprecated parameter(s)
Next Topic:	automatic startup on AS400

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 19 11:45:06 CDT 2026