|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
May 14th, 2004, 05:56 PM
|
|||
|
|||
|
Changing a user's tablespace
Hello
I have really two questions I created a user (say Scott) and forgot to assign Scott to the USERS tablespace. In this case, where will Scott store all his data?(which tablespace) and how do I change scott's tablespace (whatever it is) to the USERS tablespace. Thanks, I am lost on this one Robert
|
|
#2
May 14th, 2004, 06:51 PM
|
|||
|
|||
|
In case if you dont assign any tablespace while creating USER then default tablespace will be SYSTEM, you can change tablespace of any user by following command.
first connect with the user where you have created this user. ALTER USER scott default tablespace USERS quota unlimited on USERS / must assign quota otherwise you cannot run any SQL statement.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Changing a user's tablespace |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
