| sm_ahmeds |
Posted: Apr 29, 2007 01:56:41 PM |
Total Post: 53
Joined: Apr, 2007
|
hi.......i want to know how to create an index for an existing table (payroll) which is in USERS tablespace in another tablespace TB_INDEX.
And also please help me in creating the table in USERS tablespace with its index in TB_PAYROLL tablespace.
THANKS |
|
|
 Ratnaker |
| Posted: Apr 30, 2007 02:42:54 AM |  |
|
Total Post: 138
Joined: Apr, 2007
|
hi,
you can user given below the statement:
CREATE INDEX emp_ename ON emp(ename)
TABLESPACE users
STORAGE (INITIAL 20K
NEXT 20k
PCTINCREASE 75)
PCTFREE 0;
Ratnaker
|
|
|
|
|
| sm_ahmeds |
| Posted: Apr 30, 2007 05:37:46 AM | |
|
Total Post: 53
Joined: Apr, 2007
|
Thanks Ratnakar......can u please tell me how to move an existing index to another tablespace without moving the table
Thanks Again
|
|
|
|
|
| Ratnaker |
| Posted: Apr 30, 2007 06:46:35 AM | |
|
Total Post: 138
Joined: Apr, 2007
|
Hi
drop index and recreate again in different tablespace.
Ratnaker
|
|
|
|
|
| Vigyan |
| Posted: Apr 30, 2007 07:07:20 AM | |
|
Total Post: 386
Joined: May, 2001
|
You can move index without dropping it using alter command.
ALTER INDEX INDEX_NAME TABLESPACE NEW_TABLESPACE REBUILD ONLINE;
Thanks,
Vigyan
|
|
|
|
|
| sm_ahmeds |
| Posted: Apr 30, 2007 10:44:01 AM | |
|
Total Post: 53
Joined: Apr, 2007
|
Thanks all for helping me.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
