import data into different tablespace 1

[wsam]

Can anyone give me the syntax that you would use to import data into a different user and tablespace from where the export file was created.

ie imp sys/manager file=x.exp ignore=y fromuser=scott touser=tiger tables=a,b,c

but where do I add that the tables are to be put into a different tablespace?

Thanks

 

[karluk]

I've never tried it, but Metalink document 1012307.6 says that you can force the import to use tiger's default tablespace by removing tigers privileges on the original tablespace.

 

[evatype2]

You don't need to use import/export if you are using 8i. You can simply use ALTER TABLE xxx MOVE TABLESPACE newtablespace name (STORAGE CLAUSE stuff if you want to change it). You do need to rebuild the table's indexes when done with an ALTER INDEX REBUILD or DROP and RECREATE the indexes.