Results 1 to 9 of 9

Thread: creating a db

  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: creating a db

    Hi

    I want to create a 9i DB with a Block Size of 8k using an existing template which was created from a DB having a Block Size of 16k.
    Using DBCA, I selected 'Manage Templates', Create Template with option:
    Using existing template.
    During configuration of this new template (using an existing template), I changed the DB_BLOCK_SIZE from 16k to 8k and completed creating the template.
    I then clicked on 'Create Database' and chose the recently created template but got:

    Code:
    ora 29339: tablespace block size 16384 does not match configured block sizes.
    The thing that confuses me is if I'm not allowed to change the Block Size of a dbt file, how comes the new template created successfully with the new DB_BLOCK_SIZE?

    Could someone please advise if I can use a 16k db_block_size template to create a 8k db_block_size DB?

    Regards
    Shajju

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Did you also change the tablespace parameters as well?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    No. Which parameters?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    29339, 00000, "tablespace block size %s does not match configured block sizes"
    // *Cause:  The block size of the tablespace to be plugged in or
    //          created does not match the block sizes configured in the 
    //          database.
    // *Action:Configure the appropriate cache for the block size of this 
    //         tablespace using one of the various (db_2k_cache_size, 
    //         db_4k_cache_size, db_8k_cache_size, db_16k_cache_size, 
    //         db_32K_cache_size) parameters.
    V9 is obsoleted & unsupported.
    Consider joining the 21st Century at your earliest convenience.
    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.

  5. #5
    Join Date
    Aug 2008
    Posts
    464
    Thanks, it's in the pipeline.

    How can I configure the cache size when the db isn't even installed yet?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I changed the DB_BLOCK_SIZE from 16k to 8k
    how & where was above done?
    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
    I changed the Block size in DBCA.

    Manage Templates
    Create New Template (using existing template)

    I'd like to add that I also used the other option I had, and that was to make a template from the production database (structure only).

    But when I try creating a db using that template, it says I need like 900GB of disk space and I only have 96GB free on the laptop. I then edited the dbt file and will really appreciate if someone could let me know if it is possible to change any paramter inside this file so that I don't need 900GB to use the .dbt file?

  8. #8
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    What are the Tablespace parameters set to within your template?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  9. #9
    Join Date
    Aug 2008
    Posts
    464
    Could you please guide me here which parameters? Sorry.

Posting Permissions

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