| tablespace [message #164124] |
Tue, 21 March 2006 22:23  |
manns
Messages: 59
Registered: March 2006
Location: Bangalore
|
Member |
|
|
hi
how to change d table space
i have some users in my database and for each database i created their tablespaces but previusly there was no tablespace for this users so all the tables r in system table space only
i want to change this to paricular user tablespace
how can i ?
pls help me regarding this
regards,
manju
|
|
|
|
| Re: tablespace [message #164130 is a reply to message #164124] |
Tue, 21 March 2006 23:24  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Did you try searching it?
Alter table TABLE_NAME move tablespace TBLSP_NAME;
Try reading manuals , it's there also.
And please try to avoid IM speak.
do not use
| Quote: |
r for are
d for the
m for am
u for you
|
[Updated on: Tue, 21 March 2006 23:25] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: tablespace [message #164373 is a reply to message #164367] |
Thu, 23 March 2006 03:41 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Come on, give it a try yourself before asking!
How many hits did Google return when you entered your keyword? (oracle move index tablespace)
My search returned 164000 hits. The first one was BINGO.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
