Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Unanswered: Temporary Segment problem

    hi all,

    when i try SQL statement in sql*plus,an exception occured,
    "Temporary Segment cannot be created in locally-managed
    tablespace".

    I found the reason in some books,it is because that I used
    some SQL KeyWord like "order".

    but I have to to that,how can I avoid this error?

    thanks for your help.

    hetao.

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi Hetao,
    Could you give us a bit more information, what was the SQL statement?
    What are you trying to do?
    Rgs,
    Breen.

  3. #3
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: Temporary Segment problem

    Hi.

    You should create a TEMP tablespace, perhaps using tempfiles.
    After you have to change the user information, so oracle knows where to put the temp segments (used by sort or joins or ...) for that user:

    alter user X temporary tablespace TEMP;

    After that your sort will perform correctly.

    have a nice day.
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

Posting Permissions

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