No question at this time
DBA Top 10
1 M. Cadot 20800
2 A. Kavsek 14900
3 M. Hidayathullah ... 10800
4 B. Vroman 7900
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1600
10 A. Hudspith 1500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48052
Total active users1733
Act. users last 24h10
Act. users last hour1
Registered user hits last week395
Registered user hits last month1204
Go up

listing files with the external table
Next thread: disable frontend on the weblogic domain
Prev thread: knowledge gain

Message Score Author Date
Hi, How can I do to load data from a directory ...... yassmine deah May 16, 2017, 23:13
Dear Yassmine, please check below link for exte...... Mirza Hidayathullah Baig May 17, 2017, 05:23
AskTom, "External Tables with multiple datafiles...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot May 17, 2017, 07:26
Thanks. But i use oracle 10g so i can't use prepr...... yassmine deah May 17, 2017, 21:29
Hi, and whou said you have to use preprocessor?...... Ales Kavsek May 18, 2017, 08:55

Follow up by mail Click here


Subject: listing files with the external table
Author: yassmine deah, Algeria
Date: May 16, 2017, 23:13, 153 days ago
Os info: redhat linux
Oracle info: oracle database 10g
Message: Hi,

How can I do to load data from a directory with multiple files using external table??

thanks
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: listing files with the external table
Author: Mirza Hidayathullah Baig, United Kingdom
Date: May 17, 2017, 05:23, 153 days ago
Message: Dear Yassmine,

please check below link for external table concept, where you may get some help or idea.

https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm

https://docs.oracle.com/cd/E11882_01/server.112/e22490/et_concepts.htm

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: listing files with the external table
Author: Michel Cadot, France
Date: May 17, 2017, 07:26, 153 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
AskTom, "External Tables with multiple datafiles":

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3015912000346648463

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: listing files with the external table
Author: yassmine deah, Algeria
Date: May 17, 2017, 21:29, 152 days ago
Message: Thanks.
But i use oracle 10g so i can't use preprocessor!!!!
How can i get around this???
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: listing files with the external table
Author: Ales Kavsek, Slovenia
Date: May 18, 2017, 08:55, 152 days ago
Message: Hi,

and whou said you have to use preprocessor?
If you want to load multiply files on 10g just list them in LOCATION section as it is shown in AskTom thread at the beginning.
If you need anything beyond that (for example if your file names change regularly, if you have compressed files, etc.), then you really need preprocessor feature and you can't "workaround" it.


Regards,
Ales

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here