Database Utilities (MOSC)

MOSC Banner

Import table data (rows) after table move to new table space/data file ?

edited Jun 20, 2018 4:50PM in Database Utilities (MOSC) 4 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center