OraFAQ Forum: SQL & PL/SQL » dumping data from *.rtf file to oracle table

Home » SQL & PL/SQL » SQL & PL/SQL » dumping data from *.rtf file to oracle table (Linux, oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dumping data from *.rtf file to oracle table [message #629414]

Mon, 08 December 2014 21:53

nischalinn
Messages: 118
Registered: May 2012
Location: nepal

Senior Member

I have to load data from multiple "rtf" files.
The data is in tabular format, I only need to know can I load the data from *.rtf files to ORACLE TABLE.

Platform: Linux
Oracle 11g
files: multiple *.rtf

Report message to a moderator

Re: dumping data from *.rtf file to oracle table [message #629415 is a reply to message #629414]

Mon, 08 December 2014 22:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL*Loader

https://docs.oracle.com/database/121/SUTIL/part_ldr.htm#i436326

yes, I know manual is for V12; but same syntax works for V11 so just Read The Fine Manual

Report message to a moderator

Re: dumping data from *.rtf file to oracle table [message #629416 is a reply to message #629414]

Mon, 08 December 2014 23:47

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

First convert your rtf file into txt/csv one.

Report message to a moderator

Re: dumping data from *.rtf file to oracle table [message #629454 is a reply to message #629415]

Tue, 09 December 2014 07:00

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

BlackSwan wrote on Mon, 08 December 2014 22:20

SQL*Loader

https://docs.oracle.com/database/121/SUTIL/part_ldr.htm#i436326

yes, I know manual is for V12; but same syntax works for V11 so just Read The Fine Manual

Or just go straight to the 11.2 version of the docs ... https://docs.oracle.com/cd/E11882_01/server.112/e22490/part_ldr.htm#i436326

Report message to a moderator

Previous Topic:	Materialized view refresh does not work
Next Topic:	Can we get back any column after DROP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:00:15 CDT 2024