DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: export option

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,

    I am trying to export a table and want to import it into a different tablespace. What option should I include in the export scripts, so that I can change the tablespaces or the column name etc


    I have a ora 7.3 which doen't have move option

    Badrinath

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    do a table level export. TABLE=schema.tablename DIRECT=Y
    COMPRESS=N

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Edit the index file and change the tablespace and create object(table) by running that script. Then try import the table, it works and loads the table you created.

    Thought to add on for what sambavan mentioned.
    Reddy,Sam

  4. #4
    Join Date
    Jan 2001
    Posts
    642
    What option do you specify to get the INDEX FILE.

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    export the table and import with SHOW=Y and that gives all the definitions of Indexes and reference tables with "REM" clause prefixed.

    Remove REM clause for table definitions and remove index definitions(unless you want to point indexes to different tablespace) and run that script.

    Bottom line, If you have object(table, index) exists import will not try to create but just loads the data. If you donot have it it tries to create.
    Reddy,Sam

  6. #6
    Join Date
    Feb 2001
    Posts
    123
    Don't forget to include the import option IGNORE=Y if you pre-create the table.

    HTH

    David.

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