|
-
You could create a script to create the indexes by using
exp parameter indexfile=filename, then export the data with the exp indexes=n parameter.
When you import the data, indexes to enforce primary keys etc. will still be built in the data tablespace though.
Then you could either edit the index creation script and modify the tablespace in which the index is created, or you could set the quota on the data tablespace to 0, and the default tablespace to the index tablespace for the user into which you are importing.
HTH
David.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|