[askdba] Hw to assign a tablespace for index?

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Wed, 26 Jan 2005 00:47:16 +0530

Hi Guys,
A user has been asked to create a tablespace data and index.
User tablespace can be assigned while creating a user, but as the name
sounds one is for INDEX. How to assing that tablespace for index only.
User can put tablespace name for creating in that, but how to put that
tablespace by default?
Any special way to create index tablespace?

 - Chirag

Other related posts: