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

Thread: IMPORTING

  1. #1
    Join Date
    Aug 2000
    Posts
    29
    I am trying to Import Oracle 7.3.3 tables into Oracle 8.1.6
    using IMP. However I keep gettin this error:
    Cannot import permanant tables into temporary tablespace.

    Why am I getting this error and does anybody know how to by-pass this so I can get these tables into my database?

    thanks,
    scotta
    J.Scott Adams

  2. #2
    Join Date
    Mar 2001
    Posts
    45
    The main reason is that, your import data (of course the table) is trying to get imported into Temp. tablespace.

    Which is not possible.

    Just ensure the error messge in detail , if possible please cut and paste the screen error message, so that we can probe further.

    Thanx
    Ramesh.
    ______________________________
    There is nothing Impossible.
    Even Impossible says
    I M POSSIBLE

  3. #3
    Join Date
    Feb 2001
    Posts
    100
    Is the default tablespace for objects that the target user creates defined as temporary?

  4. #4
    Join Date
    Nov 2000
    Posts
    344
    1) Determine which objects that IMP is trying to build in a temporary tablespace

    2) Pre-build them in a permanent tablespace

    3) run your import with ignore=Y

    -John

  5. #5
    Join Date
    Feb 2001
    Posts
    203
    Check the old database tablespaces are exist in new database! If then post the import file, We can see further. Don't forget to post error message.
    sree

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