-
Hi ,
I have been extracting data from a 4GB oracle 8.1.7 table on to a flatfile.
the script goes like this:
le
set pause off
--set newpage none
set heading off
set pagesize 0
set concat ~
set feedback off
set verify off
set linesize 1000
set trimspool on
set trimout on
set termout off
column ord noprint
select 0 ord, 'select',null,null,'rtrim('||column_name ||')'
from user_tab_columns
where table_name = upper('&&1')
and column_id=1
union
select column_id ord, '||' , '''|''' , '||' ,'rtrim('||column_name ||')'
from user_tab_columns
where table_name = upper('&1')
and column_id > 1
union
select 1000 ord, '||' , '''|''' , null, 'from &1;'
from dual
order by ord;
The OS is IBM AIX 4.3.3 patch 26. and is also 64 bit.
I invoke this using sqlplus. But at 15mb, the command terminates and when I open the small 15mb file I get eh following error:
ERROR:
ORA-01489 : result of string concatenation is too log.
What could be the problem
Please help,
Thanks,
in advance,
Geo
-
ERROR: ORA-01489 : result of string concatenation is too log.
I am getting tORA-01489 when extracting a 4GB table into a flatfile.
Please help.
Geo
-
I don't know whats goin on in this context but, advise you to thru the following thread and see the work arounds in the thread will work.
I think, Its little bit crazy to select 4GB to a flatfile with no breaks. why do you use some where criteria and break it into small files of each 500MB or so if its not the situation of having it on the single flat file.
[url]http://www.dbasupport.com/forums/showthread.php?threadid=5636[/url]
Reddy,Sam
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
|