Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what problems need to be considered in imp import in the database". In daily operation, I believe many people have doubts about what problems need to be considered in imp import in the database. Xiaobian consulted all kinds of information and sorted out simple and easy to use operation methods. I hope to answer your doubts about "what problems need to be considered in imp import in the database"! Next, please follow the small series to learn together!

1. Issues to consider in implementing imp

(1) Generate database version of dmp file, import may fail if version is higher than target database server version (source database version> target database version)

(2) If a full database export is performed by a user who is DBA or has the exp_full_database role at the time of export, the user at the time of import must also have the appropriate permissions.

(3) Whether the exported data contains LOB types, using partitioned tables, partitioned indexes, etc. If so, some preparatory work may be done before importing.

2. Order in which table objects are imported

Imp imports table objects in the same order as exp exports tables:

nImport table definitions, i.e. create objects

nImport table data

nImport index data

nCreate integrity data, views, stored procedures, triggers

nImport bitmap, function-based, and domain type indexes

3. Import Examples

(1) Import to other servers (same user)

$ imp scott/tiger@192.168.131.101_orcl full=y file=scott_tables.dmp log=scott_tables.log

(2) Import to other users

To import data under another user, specify the fromuser and touser parameters:

Fromuser specifies the original owner of the object

Touser specifies the new owner of the object

SQL> conn / as sysdba

SQL> alter user dong quota unlimited on dong_tbs;

SQL> revoke unlimited tablespace from dong;

$ imp dong/dong fromuser=scott touser=dong file=scott_tables.dmp log=scott_tables.log ignore=y;

4. important parameter

FILE: Specify file

LOG: Specify the generated log

FROMUSER: Specifies the original owner of the object

TOUSER: Specifies the new owner of the object

IGNORE: Ignore error messages

FULL: FULL=Y, represents full library import

ROWS: When ROWS=N, it means that only the table structure is imported.

At this point, the study of "what problems need to be considered for imp import in the database" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.