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

Thread: Import problem

  1. #1
    Join Date
    Dec 2000
    Posts
    16
    I'm trying to import data into a new database that has locally managed tablespaces. I'm trying to import for an export done from a database that does'nt have locally managed tablespaces. And I'm getting this error when it tries to create tha tables:
    "unable to create INITIAL extent for segment in tablespace CI_DATA"

    I understand the error but what I would like to know is how can I do an import in a db that has locally managed tablespaces, from an export that does'nt have these type of tablespace.

    Thanks in advance.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This doesn't answer your question, but provides a solution.
    1. imp system/manager file=xyz.dmp indexfile=xyz.sql
    2. edit xyz.sql and take out all the storage clauses
    3. run xyz.sql to pre-create your tables and indexes
    4. imp system/manager file=xyz.dmp ignore=y
    Jeff Hunter

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You have to use show=y option in step1. Seems marist89 forgot to mention.

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