Moving indexes

From: Karen Payten <karen_at_metz.une.edu.au>
Date: 13 Aug 93 07:08:55 GMT
Message-ID: <1651_at_grivel.une.edu.au>

Help...
All I want to do is, from an export file, import the indexes into a tablespace that is different to the one they were imported from. I exported as the owner of the objects, then I revoked all resource to all tablespaces except to the new tablespace I want the indexes in, and made it the owners default tablespace. When I imported for indexes only, as the owner again, I get the error 'no resource privilege or space quota exceeded for tablespace XXXXX' where XXXXX is the original tablespace. (I am actually going between two databases here, but with the same tablespaces).

Now, according to the BOOK, if the user does not have resource privilege on the original tablespace, then it will create the objects in the users default tablespace if they have resource privilege to it.

So what is going on. Am I missing something here???

Any advice would be greatly appreciated. Please email me direct.

---

Karen Payten
Oracle DBA
University of New England
Armidale

Email: karen_at_metz.une.edu.au

---

Received on Fri Aug 13 1993 - 09:08:55 CEST