Import data to plsql and plsql

Import data to plsql and plsql

1. TOOLS --> ODBC IMPORTER
2. TOOLS --> TEXT IMPORTER
3. sqlldr userid = zj/zj @ orcl control = D: \ test. ctl

Content of the test.csv file:

1 ah

2's

3 Yes

Test. ctl file content:

LOAD DATA
INFILE 'd:/test.csv'
Append into table test
Fields terminated ','
Optionally enclosed '"'
(
Tid,
Tname
)


Run the following command in the cmd window:
Sqlldr userid = zj/zj @ orcl control = D: \ test. ctl

Import tables from oracle databases using PLSQL

Select the table to be exported, right-click the table to be exported, or select the table to be exported from the Tools menu. At this time, you can export the table to a dmp file or an SQL script file, or PLSQL files. The import method is similar !, However, if your table has a field similar to CLOB, it can only be exported to a dmp or PLSQL file. Of course, you can use the Oracle Exp/Imp command or import or export it!

How to Use PLSQL to import data to oracle databases

The problem is not detailed enough. If you want to import the backup dmp file, you can directly execute the command line. Import data using imp for exp export. import data using impdb for oracle Versions later than 10 Gb for expdb export. For detailed operations, refer to google or Baidu.