How to import very large oracle dump?

How to import very large oracle dump?

Firstly, Make sure you have enough free disk space.

Steps:

第一步. If the system tablespace has not quite large free, you should grow tablespace manually, or set system table extend size automatically.

ALTER TABLESPACE system

AUTOEXTEND ON --turn on the auto extend

NEXT 512K

MAXSIZE 250M;

第二步. Create one bigfile tablespace

--To create a bigfile tablespace, specify the BIGFILE keyword of the CREATE TABLESPACE statement (CREATE BIGFILE TABLESPACE ...). Oracle Database automatically creates a locally managed tablespace with automatic segment space management.

CREATE BIGFILE TABLESPACE BigTableSpace

DATAFILE '/u02/oracle/data/bigtbs01.dbf' SIZE 50G