How can you see this nth row??

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

Use FILESIZE parameter in EXP to split the dump file.

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

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

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

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
;

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

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