1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ERROR on retrieving tables using INNER JOIN

Discussion in 'General' started by porknbeans, Apr 8, 2015.

  1. porknbeans

    porknbeans Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    none
    Hi,
    Code (Text):

    ORA-01114: IO error writing block to file 201 (block # 3654537)
    ORA-27072: File I/O error
    Additional information: 4
    Additional information: 3654537
    Additional information: 16384
    ORA-01114: IO error writing block to file 201 (block # 3654537)
    ORA-27072: File I/O error
    Additional information: 4
    Additional information: 3654537
    Additional information: 16384
    ORA-01114: IO error writing block to file 201 (block # 3654537)
    ORA-27072: File I/O error
    Additional information: 4
    Additional information: 3654537
    Additional information: 16384
     
    I got this error using inner join, so i found out that this query gave me problem so i've changed it to left join, using Left join query
    i successfully get the data but i have to retrieve data that does not have null value in columns, so i've made multiple AND clause conditions
    after where clause (eg.column_name is not null) but after that it gave me the same error.

    i think the reason are:
    1. It contains 10k data to look, and
    2. think the reason it also trigger that error because it has Blob columns on Table B.

    --(its confidential so i will give not the exact tables.)
    Table A has
    ID(Primary key)
    and 17 string columns

    Table B has
    ID(primary key)
    and 6 Blob columns

    ------------

    here's my query
    Code (Text):
    select A.A, A.ID, A.B, A.C,
           A.D, A.E, A.SEX, A.F,
           initcap(TO_CHAR(A.G,'MONTH MM, YYYY')) as G, A.H, A.I, A.J, A.K,
           A.L, A.M, A.N, A.O,
           A.P,
           B.A, B.B, B.C,B.D, B.E, B.F,
           B.G, B.Hfrom
           TableA A inner join TableB B ON A.ID = B.ID where
           ROWNUM<=12

    can you please help me to make this query work?