Re: How to split indexes from data?

Mike Adams <mikea_at_best.com> schreef in berichtnieuws 390fc40d$0$218_at_nntp1.ba.best.com...
> I have a new database that I created and will load using an export from
> another database. The indexes in the "source" database are stored in the
> same tablespace as the tables. In my new database I want to separate the
> indexes and store them in the INDEX tablespace. Is there any easy way to
 do
> this? (I'm running Oracle 8i)
>
> And going forward, how do I enforce the splitting of the indexes from the
> tables. I know that the "create table" and "create index" commands can
> specify the tablespace for the index, but is there any way just to set a
> default for all users so they don't have to worry about it?
>
> Please 'cc' mikea_at_best.com on responses as I'm not able to check
 newsgroups
> from work.
>
> Thanks in advance for ANY help!!!
>
> Mike
>
>

By running the following commands
imp<xx?> username/password file= log= (etc..., etc...) INDEXFILE=<filename> imp<xx> .... INDEXES=N
then edit the filename from step 1, and run it.

You can specify a default for tables, you can't specify a default for indexes.
And IMO, definitely _all_ users shouldn't be able to create tables.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed May 03 2000 - 00:00:00 CDT