Home » RDBMS Server » Server Utilities » Import and create table from a text file
Import and create table from a text file [message #635382] Sun, 29 March 2015 01:14 Go to next message
amjad_alahdal
Messages: 92
Registered: October 2013
Location: Saudi Arabia
Member
Hello guys,
I have a text file. It contains a text table that includes 6 columns. How can I import it into Oracle database. This is how the information appears in the text file.
8226	2014-05-29 06:51:10	8	0	1	0
8137	2014-05-29 06:51:18	8	0	1	0
9108	2014-05-29 06:54:18	8	0	1	0
8180	2014-05-29 06:57:15	8	0	1	0
272	2014-05-29 07:01:52	8	0	1	0
480	2014-05-29 07:02:00	8	0	1	0
9203	2014-05-29 08:06:20	8	0	1	0
8348	2014-05-29 08:08:59	8	0	1	0
595	2014-05-29 08:09:03	8	0	1	0
8224	2014-05-29 08:11:32	8	0	1	0
295	2014-05-29 08:11:45	8	0	1	0
560	2014-05-29 08:13:05	8	0	1	0
9181	2014-05-29 08:14:09	8	0	1       0


Is there any way to import this file into my table ?
I also want to use it in a button in my form builder 6i.

[Updated on: Sun, 29 March 2015 01:23]

Report message to a moderator

Re: Import and create table from a text file [message #635383 is a reply to message #635382] Sun, 29 March 2015 01:46 Go to previous messageGo to next message
John Watson
Messages: 7933
Registered: January 2010
Location: Global Village
Senior Member
http://docs.oracle.com/database/121/SUTIL/ldr_concepts.htm#SUTIL003
Re: Import and create table from a text file [message #635388 is a reply to message #635382] Sun, 29 March 2015 07:34 Go to previous messageGo to next message
BlackSwan
Messages: 26538
Registered: January 2009
Location: SoCal
Senior Member
does file reside on DB Server system?

On which system does this file reside?

In which directory does this file reside?

What are the OS file permissions on this file?
Re: Import and create table from a text file [message #635390 is a reply to message #635388] Sun, 29 March 2015 08:48 Go to previous message
Littlefoot
Messages: 21480
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As you mentioned Forms 6i (which is, I presume, client-server application - unless you deployed it on web), then the file is on your PC. Furthermore, it means that SQL*Loader is an option which would work.

First develop SQL*Loader part of the story - create a control file and make sure it successfully & correctly loads data into a table. Put SQLLDR command line into a batch file. Finally, the HOST built-in will be used in a WHEN-BUTTON-PRESSED trigger and call previously created batch file (which will, in turn, load data into a table).
Previous Topic: impdp to different version
Next Topic: Expdp using query
Goto Forum:
  


Current Time: Mon Jun 17 13:59:44 CDT 2019