OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » tablespace

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

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

Report message to a moderator

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 #164337 is a reply to message #164130]

Thu, 23 March 2006 00:35

manns
Messages: 59
Registered: March 2006
Location: Bangalore

Member

hi,

it helps to move the tablespace

but after moving the tablespace it is giving the error when query the any table becouse all the user_indexes status are now unusable and indexes are in still system tablespace only
how to solve this

regards,
manju

Report message to a moderator

Re: tablespace [message #164338 is a reply to message #164337]

Thu, 23 March 2006 00:41

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Rebuild those indexes. Look into the manuals on how to rebuild the indexes.

regards.

Report message to a moderator

Re: tablespace [message #164367 is a reply to message #164338]

Thu, 23 March 2006 03:07

manns
Messages: 59
Registered: March 2006
Location: Bangalore

Member

thank you
it is working now
but still indexes are in system tablespaces only

how to move this respective user tablespaces

regards,
manju

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.

Report message to a moderator

Previous Topic:	general query tuning
Next Topic:	Tablespace Fragmentation !!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 19:37:45 CDT 2025