Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    232

    Lightbulb Unanswered: Application-defined or object-defined error 40002

    I am using 6.5 .
    Here is the error that i get
    Think that tempdb is small how do i change that or what is this error about'

    --------------------------
    AIMSMan
    ---------------------------
    Application-defined or object-defined error 40002

    37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object '##RevByNetSALIMJUMMA' in database 'tempdb' because the 'default' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.( 1105)

    ODBC

    ---------------------------
    Abort Retry Ignore
    ---------------------------
    bigfoots

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You'll have to increase the data device where tempdb resides (I do hope that you have it on a separate device) and then expand the database. I do not recommend to use segments on tempdb.

  3. #3
    Join Date
    Oct 2003
    Posts
    232
    How , i am new from oracle

    i have set 2 devices as

    1) Data
    2) log

    Pls tell me in detail

    Tks
    SEJ
    bigfoots

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Default segment corresponds to data device.

Posting Permissions

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