Import table data (rows) after table move to new table space/data file ?
Oracle Version 8i
Windoz 2000 server
Scenario:
- export table and data while the table belongs to table space X
- move the table to a new table space (new data file) Y
- truncate table
- import data into table
For some reason I dont think the import will work because the export was done when the table lived in table space X.
Can anyone confirm ? And perhaps suggest work around ?
thank you in advance.
Scenario:
- export table and data while the table belongs to table space X
- move the table to a new table space (new data file) Y
- truncate table
- import data into table
For some reason I dont think the import will work because the export was done when the table lived in table space X.
Can anyone confirm ? And perhaps suggest work around ?
thank you in advance.
0