Oracle Import and Export Files supplement

These two days did the import and export table data for Oracle.

1.oracle provides three ways to import and export files, (1) Oracle Export/import (2) SLQ export/import (3) PL/SQL Export Import

The second method is suitable for import and export of single or several tables, and the amount of data exported is smaller.

If it is a large amount of data or a table is more, it is best to use the first method. The third method must have PL/SQL.

2. Precautions

(1) When exporting a table, the second way you cannot export a table with a BLOB or CLOB field must use the first method.

(2) When importing a table, the first, two ways cannot import a table with a BLOB or CLOB field, you need to import the table using CREATE DATABASE link, the step is to first create the database link, and then use the following statement to import the table, create Table table_name AS SELECT * from [email protected]

(3) In the import process encountered the following error, ora-01659 unable to allocate more than 93 minextents.

The reason is that the table space exceeds its maximum value (32G),

WORKAROUND: You need to add a tablespace file with the statement:

ALTER tablespace table space name ADD datafile ' data file path ' SIZE 500M Autoextend On NEXT 1M MAXSIZE UNLIMITED;

Oracle Import Export File supplement