SQL>
SQL> create directory external_tables as 'C:\Oracle\oradata\external';
Directory created.
SQL>
SQL> -- Create the external table:
SQL> create table student_emails_ext
2 (id char,
3 firstname varchar(40),
4 lastname varchar(40),
5 email varchar(80) )
6 organization external
7 (
8 type oracle_loader
9 default directory external_tables
10 location ('students_test.txt')
11 ) reject limit unlimited
12 /
Table created.
SQL>
SQL> drop directory external_tables;
Directory dropped.
SQL>
SQL> drop table student_emails_ext;
Table dropped.