Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: partitions stopped getting created

    Hi

    I have a 9i db. For one tablespace, the data of which I moved to a new tablespace in another volume, the partitions have stopped getting created.

    This new tablespace had 2 datafiles with max size of 2000M each and 'Increment' set to 500M.

    The size of the second datafile is showing as 1600M and the used size is showing 1502M...

    Q: At what stage is a datafile extended?

    Q: Could the case be that this second datafile cannot be extended and hence partitions stopped getting created.

    The log shows: Inserted partition key does not map to any partition.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    I might be wrong but I don't think Oracle 9i never had "automatic" partitions. You always had to create a trigger or some other maintenance procedure to create new partitions.

    My first guess is that your procedure to create new partitions is no longer working.

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    Thanks Shammat.

    Can I check any log for details on partition creation like what happened when the create partition proc ran?

    Maybe the alert log but not sure what to grep from it?

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Well as this is most probably a procedure/trigger/shell script you created you should know.

    I don't know your system

  5. #5
    Join Date
    Aug 2008
    Posts
    464
    Just wanted to add:

    I've checked the alert log for 'unable to extend table......' but could not find anything.

    The proc that creates partitions is running because there are 1000s of other tables which are fine.

    That's why I wanted to understand whether creating partitions stop getting created if the tablespace (i.e., datafile) cannot be extended due to the increment size being too large (there is not enough free space in that datafile)?

    Just looking for any place I can check what happened when the proc tried to extend the table.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have a 9i db. For one tablespace, the data of which I moved to a new tablespace in another volume, the partitions have stopped getting created.
    >The proc that creates partitions is running because there are 1000s of other tables which are fine.

    Does the proc that creates partitions know about new tablespace?

    From my perspective unless or until you can post actual error code & message,
    no problem really exists.

    It is difficult to fix something when no clues about it being broken exist.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Aug 2008
    Posts
    464
    Yes the proc knows about the new tablespace because there is a table called 'Maintain_tablespaces' to which the new tablespace name is added.

    Actually I didn't create the db. I was called in to support it. That's why some of my questions may seem naive.

    There is a proc in a package called 'MAINTAIN_TABLE' which I believe creates the partitions every day.

    Kindly guide me in the right direction? If you need any more info, please don't hesitate to ask.

  8. #8
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    post the code for MAINTAIN_TABLE
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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