kurs:external_tables
Differences
This shows you the differences between two versions of the page.
|
kurs:external_tables [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:external_tables [2014/09/10 21:22] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | als privilegierter user (zb system) | ||
| - | <code> | ||
| - | SQL> create directory emp_data as 'c:\temp'; | ||
| - | Verzeichnis wurde erstellt. | ||
| - | |||
| - | |||
| - | SQL> grant read,write on directory emp_data to hr; | ||
| - | |||
| - | Benutzerzugriff (Grant) wurde erteilt. | ||
| - | </code> | ||
| - | |||
| - | <code> | ||
| - | create table ext_emp_data | ||
| - | ( | ||
| - | vorname varchar2(100), | ||
| - | nachname varchar2(100), | ||
| - | gehalt number | ||
| - | ) | ||
| - | organization external | ||
| - | ( | ||
| - | type oracle_loader | ||
| - | default directory system.emp_data | ||
| - | access parameters | ||
| - | ( | ||
| - | records delimited by newline | ||
| - | badfile 'emp.bad' | ||
| - | logfile 'emp.log' | ||
| - | fields terminated by ',' | ||
| - | missing field values are null | ||
| - | ( | ||
| - | vorname, | ||
| - | nachname, | ||
| - | gehalt | ||
| - | )) | ||
| - | location ('emp.csv') | ||
| - | ) reject limit unlimited; | ||
| - | </code> | ||
kurs/external_tables.txt ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
