Storage while importing tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Storage while importing tables

  1. #1
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Storage while importing tables

    Hi,

    Is there any way to import tables without their default storage settings? I need to import few tables, but I want those tables to use default storage setting of tablespace and not of their default storage.

    Thanks

    Sameer

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    That's a good one, I'm not sure. I think you could import the DDL and then spool a alter script to get the storage to match the tablespace default. Then import you data, that may work.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    another suggestion :

    import to an indexfile.
    alter storage for objects.
    create objects using indexfile.
    Import data only (ignore errors).
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Before that I though If I import into another tablespace and later moved to the required tablespace, then it might take the new tablespace storage parameters.. but it doesn't change defaults...

    Bit of tedious job of editing storage parameters. But thanks a lot.. it did the required.

    Thanks

    Sameer

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