-
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?
Jeff Hunter
-
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
;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|