 How to Create Oracle Directory for remote location [message #183704] |
Sat, 22 July 2006 06:11  |
junaidsystems
Messages: 30
Registered: June 2006
|
Member |
|
|
Can an oracle directory be created for remote location other the the database server??? i.e on middle tier(App server).
I want to read file in external table 'data.csv' which is on remote location(App server directory).
SQL> create or replace directory foo_dir as '/tmp';
CREATE OR REPLACE PROCEDURE test AS
BEGIN
EXECUTE IMMEDIATE 'create table ext_tab
(
first_name varchar2(30),
last_name varchar2(30),
home_phone varchar2(12))
organization EXTERNAL
(type oracle_loader
default directory EXT_DIR
access parameters
( records delimited by newline
badfile ''data_invalid.bad''
logfile ''log_data.log''
fields terminated by '',''
OPTIONALLY ENCLOSED BY ''"''
missing field values are null
)
Location (''data.csv'')
)
reject limit unlimited';
END;
where 'data.csv' is on remote location.
what should I add before '/tmp'???
Thanks in advance.
[Updated on: Sat, 22 July 2006 07:28] Report message to a moderator |
|
|
|
|
|
|
|
| Re: How to Create Oracle Directory for remote location [message #250736 is a reply to message #183707] |
Wed, 11 July 2007 02:08  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Reported Message:
Reported By: gowthamsen
On: Wed, 11 July 2007 09:04
"Hi, Could you please explain the steps, in order to access the files in remote machine thorougth external table. Here you have explained NFS mount. Could you please explain, how to do that. Thank you, Regards, Gowtham Sen."
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
