| Coalescing tables? [message #50171] |
Tue, 05 March 2002 02:51  |
Robin Urff
Messages: 9
Registered: March 2002
|
Junior Member |
|
|
Hello!
A little question:
I have a database, which has a lot of extents on the tables and indexes (reaching 400 sometimes). The indexes I coalesce using the statement below.
alter index schema.MyIndex rebuild tablespace MyTableSpace
storage (initial 40K next 200K pctincrease 0 maxextents 100 );
alter tablespace MyTableSpace coalesce;
Can I perform this statement on a table?
(off course I will use ALTER TABLE!)
And is there a way to prevent this?
Robin
|
|
|
|
| Re: Coalescing tables? [message #50173 is a reply to message #50171] |
Tue, 05 March 2002 04:09  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
I think you have to use
alter table xxx move storage ...
then you coalesce the tablespace.
FYI in the alter index command above, you have the initial at 40K and next at 200K. Is this just a example or a real command? If you have tables/indexes with over 400 extents, you may wanna make bigger extents, based on what is available and feasible.
Later.
|
|
|
|
| Re: Coalescing tables? [message #50183 is a reply to message #50171] |
Tue, 05 March 2002 07:03 |
kiran srirama
Messages: 14
Registered: March 2002
|
Junior Member |
|
|
hi..
you can't user coalaesce on a table.
coalasce happens only at tablespace level.
you could use
ALTER TABLESPACE TS_1 COALAESCE;
(remember: ON OFFLINE TABLESPACE OFCOURSE)
Also, alter ur tablespace parameters such that pct increase in non-zero. this makes smon to coalasce ur tablespace automatically.
hope this helps u
regards
kiran
|
|
|
|
| Oracle and Pro "C" [message #50186 is a reply to message #50183] |
Tue, 05 March 2002 07:29 |
balu
Messages: 23
Registered: March 2001
|
Junior Member |
|
|
Hello,
Is there any simple tutor that teaches how use Pro c with simple examples(Like creating tbales...etc)
What is the advantage of using Pro c..?
Why we should go for pro c..?
Thanks fro all your sugesstions
Thanks,
-balu.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
