Index tablespace for a Database

How to assign an index tablespace for a database permanently, so that whatever indexes we are creating in the database, should automatically goes to that tablespace i.e. we neednot supply the tablespace name during index creation.

Questions by kishore.giri   answers by kishore.giri

Showing Answers 1 - 3 of 3 Answers

kailasTile

  • Dec 17th, 2007
 

There is no such provision in oracle to have default index tablespace. Workaround is- you can have a job which will scan for indexes in other tablespaces and rebuild into desired one.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions