I think you have to create the table (with no rows) on the proper tablespace and then import the data with IGNORE=Y
1. Get the creation script, user INDEXFILE option and set ROWS=N when import.
2. Run the script to create table
3. Import with IGNORE=Y option
Queyon




Reply With Quote