Quote Originally Posted by PAVB View Post
That sounds like a plan.

Google it. Read Oracle documentation -it's free! - then come back with your doubts.
I got the answers. However, i'm facing another problem. I did

Code:
create or replace directory emp_dir
as 'F:\emp_dir';
The folder is created in F:\....It did not show up even though the transaction succeeded...I have all grants i need.

I'm running Win Vista x32...

After the above query, i did:

Code:
drop table emp_data;

CREATE TABLE emp_data
  (first_name  VARCHAR2(20)
  ,last_name   VARCHAR2(20)
  , email     VARCHAR2(30)
  )
ORGANIZATION EXTERNAL
(
 TYPE oracle_loader
 DEFAULT DIRECTORY emp_dir
 ACCESS PARAMETERS
 (
  RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
  NOBADFILE
  NOLOGFILE
  FIELDS
  ( first_name POSITION ( 1:20) CHAR
  , last_name POSITION (22:41) CHAR
  ,  email   POSITION (43:72) CHAR )
 )
 LOCATION ('emp.dat') ) ;
The table creation succeeded, but when i do select * from emp_data;

Error starting at line 1 in command:
select * from emp_data
Error report:
SQL Error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file emp.dat in EMP_DIR not found
ORA-06512: at "SYS.ORACLE_LOADER", line 19
29913. 00000 - "error in executing %s callout"
*Cause: The execution of the specified callout caused an error.
*Action: Examine the error messages take appropriate action.
Any help will be appreciated....Thanks