All,
While using External table in Oracle9 for a flat file data,
the 1st step involved is CREATE or REPLACE DIRECTORY testdir AS 'c:\ext_dir';
My question is 'c:\ext_dir' is the the Oracle Server directory ? OR a directory in your local machine ?
Basically, where should the flat file will reside ?
Should your DBA create this DIRECTORY object for you ?
If yes, then granting read/write previladges on such directory to developer users won't hamper the security issue ??
Other question is, so u have to drop and create table every time ur flat file got as a new one ??
UTL_FILE.
How abt using this UTL_FILE of Oracle ?
Where should your flat file reside ?
What are things involved to access such directory ?
Thanx
While using External table in Oracle9 for a flat file data,
the 1st step involved is CREATE or REPLACE DIRECTORY testdir AS 'c:\ext_dir';
My question is 'c:\ext_dir' is the the Oracle Server directory ? OR a directory in your local machine ?
Basically, where should the flat file will reside ?
Should your DBA create this DIRECTORY object for you ?
If yes, then granting read/write previladges on such directory to developer users won't hamper the security issue ??
Other question is, so u have to drop and create table every time ur flat file got as a new one ??
UTL_FILE.
How abt using this UTL_FILE of Oracle ?
Where should your flat file reside ?
What are things involved to access such directory ?
Thanx
