DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: How can you see this nth row??

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hi :
    I am doing an export of a table that is 130 MB and has 5.6 million rows.. The export fails and I get errors that are related to something that is > 2gb filesize limit errors..

    Also the error message mentions about a particular rownumber of a table. How can I see that row ??. .

    exporting table VPCSRCEE
    EXP-00015: error on row 3727036 of table VPCSRCEE, column VPC_TECH_KEY, datatype 2
    EXP-00222:
    System error message 28
    EXP-00002: error in writing to export file
    EXP-00002: error in writing to export file
    EXP-00000: Export terminated unsuccessfully

    SQL> select * from tabs where table_name='VPCSRCEE';

    TABLE_NAME TABLESPACE_NAME
    ------------------------------ ------------------------------
    CLUSTER_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS
    ------------------------------ ---------- ---------- ---------- ----------
    INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS
    -------------- ----------- ----------- ----------- ------------ ----------
    FREELIST_GROUPS B NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT
    --------------- - ---------- ---------- ------------ ---------- ----------
    AVG_ROW_LEN DEGREE INSTANCES CACHE TABLE_LO
    ----------- ---------- ---------- ----- --------
    VPCSRCEE LARGETBL
    10 40 1 255
    117964800 3276800 1 500 0 1

    TABLE_NAME TABLESPACE_NAME
    ------------------------------ ------------------------------
    CLUSTER_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS
    ------------------------------ ---------- ---------- ---------- ----------
    INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS
    -------------- ----------- ----------- ----------- ------------ ----------
    FREELIST_GROUPS B NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT
    --------------- - ---------- ---------- ------------ ---------- ----------
    AVG_ROW_LEN DEGREE INSTANCES CACHE TABLE_LO
    ----------- ---------- ---------- ----- --------
    1 N 5666328 15044 155 883 0
    17 1 1 N ENABLED


    Thanks, ST



  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Use FILESIZE parameter in EXP to split the dump file.

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    But Tamil.. the tablesize is only 130 MB.. Why should I even split the export file..

    Secondly I have one more question today, for which I did not get the answer I am looking for.. I am still curious on RBS..

    Thanks, ST2000

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What size is the .dmp file in your filesystem after it crashes? Do you have free space in that filesystem?
    Jeff Hunter

  5. #5
    Join Date
    Oct 2000
    Posts
    449
    Thanks Jeff.. May be the size in the filesystem could be a problem as well since my sysadmin got back on this and created a seperate filesystem only for exports. I am doing the export again. If the table is 130 MB, the dmp file cannot be > than 130MB right.. ST2000

  6. #6
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Execute SQL like this one:

    select t.rowid, t.*
    from
    u_name.u_table t,
    (select rowid ri, rownum rn from u_name.u_table) t1
    where t.rowid = t1.ri and t1.rn = YOU_REC_NUMBER
    ;

  7. #7
    Join Date
    Oct 2000
    Posts
    449
    Shestakov : I am not clear on the syntax of your SQL and it is giving me errors.. Just take a table name as EMP and can you rewrite the query.. I want 100th row..
    Thanks, ST2000

  8. #8
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    select t.rowid, t.*
    from emp t,
    (select rowid ri, rownum rn from emp) t1
    where t.rowid = t1.ri and t1.rn = 100
    ;

Posting Permissions

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


Click Here to Expand Forum to Full Width