Export/Import in table mode

[elaine3839]

Hi,

By reading the Exp/Imp documentations, I feel that the CREATE TABLE statement will ONLY be in the export file when there is no rows being exported. So my question is:

If there are rows exported, then when we use the .dmp file to Import, we need to have the table schema set up already?

Also, is there anyway for us to specify which tablespace we'd like the tables being imported to? I know there is a parameter called tablespace for Import, but that doesn't seem to be for this purpose. i.e. I feel that's only useful when Exported in other modes other than TABLE mode.

Thanks for your help!!!

[marist89]

Originally posted by elaine3839
Hi,

If there are rows exported, then when we use the .dmp file to Import, we need to have the table schema set up already?

No, the table definition will be exported even if you export rows.

Also, is there anyway for us to specify which tablespace we'd like the tables being imported to?

No, the way you would do that with export/import is:
1. export the tables
2. imp with indexfile=xyz.sql
3. edit xyz.sql and change the tablespace location
4. create your tables and indexes from xyz.sql
5. import with ignore=y

However, the better way to move tables and indexes is via ALTER TABLE MOVE and ALTER INDEX REBUILD in 8i.