SQL> DROP TABLE customers; SQL> CREAT TABLE customers ( 2 name VARCHAR(32), 3 SSN CHAR(10) PRIMARY KEY, 4 no INTEGER CHECK (no >= 0) ); SQL> COMMIT;
|
|
undcemcs02> sqlldr C##user.id/password@//65.52.222.73:1521/cdb1 \ control=customers.ctl
undcemcs02> cat dbload.sh sqlplus C##user.id/password@//65.52.222.73:1521/cdb1 @create.sql sqlldr C##user.id/password@//65.52.222.73:1521/cdb1 control=customers.ctl undcemcs02> sh dbload.sh
Mum’s the word. |