Assigning tablespace [message #178179] |
Tue, 20 June 2006 00:17 |
gajini
Messages: 262 Registered: January 2006
|
Senior Member |
|
|
Default tablespace DATA01 of user1 got full,
now i want to assign another tablespace DATA02
to the user.
How can i assign it so that further objects creation will
take place in DATA02?
|
|
|
Re: Assigning tablespace [message #178193 is a reply to message #178179] |
Tue, 20 June 2006 01:43 |
aciolac
Messages: 242 Registered: February 2006
|
Senior Member |
|
|
If You will assign default tablespace DATA02 to user, all objects which will be created later in the scheme of user, and will not nave TABLSESPACE clause explicitly indicated, will be create in DATA02.
|
|
|
|
Re: Assigning tablespace [message #178327 is a reply to message #178179] |
Tue, 20 June 2006 11:18 |
smartin
Messages: 1803 Registered: March 2005 Location: Jacksonville, Florida
|
Senior Member |
|
|
Make sure you have your tablespace and datafile concepts straight. You assign tablespaces to users (as defaults), or tablespaces to specific objects (tables).
But you assign datafiles to tablespaces. So if a tablespace is becomming full, just add another datafile to it. Or, increase the size of the existing datafile(s).
|
|
|