How can you see this nth row??

[st2000]

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

[tamilselvan]

Use FILESIZE parameter in EXP to split the dump file.

[st2000]

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

[marist89]

What size is the .dmp file in your filesystem after it crashes? Do you have free space in that filesystem?

[st2000]

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

[Shestakov]

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
;

[st2000]

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

[Shestakov]

select t.rowid, t.*
from emp t,
(select rowid ri, rownum rn from emp) t1
where t.rowid = t1.ri and t1.rn = 100
;