Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Buda
    Posts
    3

    Unanswered: ORA-08224 - From DB2 To Oracle with HS GateWay

    Hi,

    I tried this:

    Insert Into Table_Name Select * From Folder.DB2-filename@Address
    and I got the ORA-08224 error message
    I couldn't find it but it is about some invalid blocksize

    The DB2 file has some 200 columns and some of it is about 1000 chars long.

    If I change the "Insert" mentioned above with where, or if I select only some of it's columns the insert works.

    We use:
    Oracle 9i, on AIX
    OS400 V5.1 m0 on AS400
    HS GateWay

    What should I change to be able to perform this "Select * From" ?

    Thanks
    T.

  2. #2
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    Can you post your init.ora file?

  3. #3
    Join Date
    Sep 2003
    Location
    Buda
    Posts
    3

    init.ora

    >Originally posted by Ida Hoe
    >Can you post your init.ora file?

    I'm not a DBA so it took a long time to find our init.ora:

    *.aq_tm_processes=1
    *.background_dump_dest='/oracle/admin/RDW/bdump'
    *.compatible='9.2.0.0.0'
    *.control_files='/oradata/RDW/control01.ctl','/oradata/RDW/control02.ctl','/orad
    ata/RDW/control03.ctl'
    *.core_dump_dest='/oracle/admin/RDW/cdump'
    *.db_block_size=16384
    *.db_cache_size=1073741824
    *.db_domain=''
    *.db_file_multiblock_read_count=64
    *.db_files=400
    *.db_name='RDW'
    *.dbwr_io_slaves=4
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=RDWXDB)'
    *.enqueue_resources=12000
    *.fast_start_mttr_target=300
    *.hash_join_enabled=TRUE
    *.instance_name='RDW'
    *.java_pool_size=115343360
    *.job_queue_processes=10
    *.large_pool_size=8388608
    *.log_archive_dest_1='location=/oradata/RDW/arch'
    *.log_archive_dest_2='location=/oradata/RDW1/arch'
    *.log_archive_dest_3='location=/oracle/oradata/cs4/rdw_arch'
    *.log_archive_dest_4='location=/oradata/RDW3/rdw_arch'
    *.log_archive_dest_state_1='DEFER'
    *.log_archive_dest_state_2='DEFER'
    *.log_archive_dest_state_3='DEFER'
    *.log_archive_format='RDW_%t_%s.arch'
    *.log_archive_start=true
    *.max_enabled_roles=100
    *.open_cursors=500
    *.pga_aggregate_target=419430400
    *.processes=250
    *.query_rewrite_enabled='true'
    *.remote_login_passwordfile='EXCLUSIVE'
    *.shared_pool_size=268435456
    *.sort_area_size=33554432
    *.star_transformation_enabled='FALSE'
    *.timed_statistics=TRUE
    *.undo_management='AUTO'
    *.undo_retention=3600
    *.undo_tablespace='UNDOTBS'
    *.user_dump_dest='/oracle/admin/RDW/udump'
    *.utl_file_dir='*'

  4. #4
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    I think your logical block is too large. This is something the DBA should change though. If they change db_block_size to 8192 it will probably work. Do you have a DBA?

  5. #5
    Join Date
    Sep 2003
    Location
    Buda
    Posts
    3
    We have DBA and he said the the db_block_size is a very basic parameter can be set only at the database creation and cannot be changed in an existing database. Wi will try to set smaller block size when create a test database.
    In the meantime I would appreciate any other idea to try.
    thans

    T.

Posting Permissions

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