Creating External Table DDL - Oracle 10g
Code:
CREATE TABLE oldemp ( fname char(25), lname char(25) )
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY emp_dir
ACCESS PARAMETERS
(RECORDS DELIMINATED BT NEWLINE
NOBADFILE
NOLOGFILE
FIELDS TERMINATED BY ',' (fname POSITION (1:20) CHAR, lname POSITION (22:41) CHAR)
)
LOCATION ('emp.dat') )
PARALLEL 5
REJECT LIMIT 200;
1. Can you please explain this part:
Code:
ACCESS PARAMETERS
(RECORDS DELIMINATED BT NEWLINE
NOBADFILE
NOLOGFILE
FIELDS TERMINATED BY ',' (fname POSITION (1:20) CHAR, lname POSITION (22:41) CHAR)
)
2. Can you please explain what PARALLEL 5 is? and Why do we need it?
I will google anyway. Your help would not harm anyway