Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003

    Unanswered: Oracle tablespace requirement analysis

    I have a set of partitioned tables in database. The partitions of a single table are spread across tablespaces. Also 1 tablespace is holding partitions of multiple tables. The structure is somehow like this-

    No code has to be inserted here.

    My Program design
    As per the program delivered to us, the EXCHANG PARTITION concept is used.

    The principle of scripts is as following-
    1) Create the temporary table structure as of main table in the tablespace where partition is existing.
    2) Insert into temporary table the entire data of 1 partition.
    3) Then Exchange the partition with temporary table.

    As per the program design all the tables scripts run in parallel. This means the copies of partitions of different tables are created at the same time. This means there should ne enough space in tablespace to hold all the partitions of tablespace. The space requirement is ‘Combined size of all partitions of particular tablespace’.

    This means if sum of partitions (TB_353822332_142 , TB_1227160661_142 and TB_1572829648_142) of tablespace PDB_TB_DS1 is 30 GB I need 30 GB more space in the same tablespace added.

    Help required
    Is my analysis of space requirement correct? Am I right in saying that DBS need to increase the space in each tablespace as ‘sum of all partitions of that tablespace’.

    This leads to space requirement of around 900 GB in our application. Can’t the DBAs add the required datafiles for duration of our program and then remove the added datafiles. Are there any chances of data loss by having this approach? Please keep in mind that our program execution is one off task.
    Last edited by varun_751980; 11-21-11 at 08:02.

  2. #2
    Join Date
    Nov 2003

    55 views , 0 replies

    I would appreciate if somebody can have a look and put some light please

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    nobody here owes you any response.

    >Can’t the DBAs add the required datafiles for duration of our program and then remove the added datafiles.
    Nothing is impossible for the person who does not have to actually do it.
    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.

Posting Permissions

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