Home » RDBMS Server » Server Administration » Default tablespace
Default tablespace [message #208164] Fri, 08 December 2006 07:04 Go to next message
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
Re: Default tablespace [message #208169 is a reply to message #208164] Fri, 08 December 2006 07:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you try:
ALTER DATABASE DEFAULT TABLESPACE <new_tablespace_name>;
Re: Default tablespace [message #208170 is a reply to message #208164] Fri, 08 December 2006 07:20 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
that worked.thanks
Previous Topic: obsolete and/or deprecated parameter(s)
Next Topic: automatic startup on AS400
Goto Forum:
  


Current Time: Sat Dec 03 05:44:07 CST 2016

Total time taken to generate the page: 0.27014 seconds