Export/Import in table mode
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Export/Import in table mode

  1. #1
    Join Date
    May 2001
    Posts
    285
    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!!!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width