Jun 29 2008, 01:06 PM
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
Jun 29 2008, 01:40 PM
"I am in desperate situation . "
"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?
Jun 29 2008, 04:08 PM
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
default directory log_dir
access parameters (records delimited by newline
create table ora_alert_log
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)
select line_number, line_text
where upper(line_text) like '%ORA-%';