Summary of Oracle Load data import method ____oracle

1. Initial data:

For example:

LOAD DATA
INFILE *
badfile './data24. Bad '
discardfile './data24. DSC '
APPEND into TABLE ge_l_temp
Fields terminated by ";" Optionally enclosed by ' "
(
  ID,
  c_dest,
  r_dest,
  gr_src,
  AP
)
begindata
3482845;0;0;0; " 1 ";" 41112830 "
3482846;0;0;0;" 1 ";" Thx "; 3;105

2. The statement used under CMD:

Sqlldr Userid=showdata@prod Control=data.ctl

One of the key to look at the service name:

@prod

1. This service name must be configured in the Tnsnames.ora under the server, not under client.

Prod=
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 1.1.1.1) (PORT = 1521))
)
(Connect_data =
(service_name = prod)
)
)

2). Ping: tnsping prod

3) Check the monitoring status: Lsnrctl status

If no start, use command start: Lsnrctl start