oracle11g Importing *.DMP data files

IMP command to import data:
Imp username/[email protected] file=xxx.dmp fromuser=xxx touser=xxx tables= (xxx,xxx) [Ignore=y]
Where 1.SID is the database name; 2.fromuser refers to the user name of the other database; (the user who created the XXX.DMP database file); If the fromuser is more than one table space, use () to enclose it: fromuser= (A, B) 3.touser refers to the user name of your database; (the user who will import the XXX.DMP database file); touser parameter Imitation fromuser parameter; 4. To import only a subset of tables, use the tables parameter, enclose the table to be imported, and if you want to import all, You do not need to specify the tables parameter; 5.ignore=y: The above may be a problem, because some tables already exist, and then it will be an error, the table will not be imported, after adding ignore=y can be imported. Errors may be encountered during the import process: 376 Error:

Ora-00376:file string cannot is read at this time
File string This operation is not readable
Cause:attempting to read from a file, which is not readable. Most likely the file is offline.
(1) Reason: Table space is offline
    Workaround: Check the tablespace status and put it online:
Sql>alter tablespace table space name online;

(2) Cause: The file that corresponds to the tablespace does not exist
    Workaround: Create the corresponding tablespace ( the corresponding tablespace size is determined according to the size of the file you imported ) under the file corresponding to the table space that prompted the error

Sql>create tablespace Ceimsexchange

  2 datafile ' F:\asmfile\asm_file.dbf '

  3 size 100M autoextend on Next 10M Maxsize 2048M

  Extent Management Local

  Segment Space management auto;

Note f:\asmfile\ This path must be built first.

oracle11g Importing *.DMP data files