Help - Search - Members - Calendar
Full Version: bfile
Oracle DBA Forums > Oracle > Oracle Forum
Vugar
Hi . I am in desperate situation . Please help me. how I keep texfile in table in Oracle. Please give example .Again i say help me, give me example in PL/SQL . Thanks
HAL9000
"I am in desperate situation . "

Despirate?

"how I keep texfile in table in Oracle."

CLOB datatypes http://www.dba-oracle.com/t_blob.htm

" give me example in PL/SQL "

Why? It does not use PL/SQL!

Did you even attempt to look this up in the documentation?
andrew kerber
Are you trying to load a textfile into Oracle? this is an example of how to do that:

create directory log_dir as '/u01/app/oracle/admin/orcl/bdump';
grant read on directory log_dir to dba;
grant write on directory log_dir to dba;
drop table alert_log;

create table alert_log
(txt_line varchar2(512)
)
organization external
(type ORACLE_LOADER
default directory log_dir
access parameters (records delimited by newline
fields
(txt_line char(512))
)
location ('alert_orcl.log')
);
/*
create table ora_alert_log
(LINE_NUMBER NUMBER,
LINE_TEXT VARCHAR2(512))
tablespace tools;

alter table ora_alert_log add constraint xpkora_alert_log
primary key (line_number) using index tablespace tools;



truncate table ora_alert_log;
insert into ora_alert_log (
select rownum, rtrim(txt_line)
from alert_log);

select line_number, line_text
from ora_alert_log
where upper(line_text) like '%ORA-%';
*/
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.